Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. karysmithers

    Access: update data

    Hi I wonder if anyone could help me with a query. I have two tables with the following fields (see example below) AllMarks: Student#, AssignmentName, Mark FinalMarks: Student#, Mod1Ass1, Mod1Ass2, Mod1Ass3, Mod2Ass1, etc The marks for each assignment are stored in AllMarks - each assignment...
  2. karysmithers

    Union query and linking excel sheets to Access

    Hi, I have about 20 offices who send an excel notebook consisting of 10 sheets to Head Office per month. I need to link them (name includes OfficeName and date eg: PLE01012012), create a union query, and copy the records to a temporary file (which is cleared before each copy). Does anyone know...

Part and Inventory Search

Back
Top