Results 1 to 2 of 2
  1. #1
    Grahamiwa is offline Novice
    Windows 98/ME Access 97
    Join Date
    May 2011

    Combining 3 update queries for a single table

    We have a database that is queried through Access 97 front end. There is a table that stores Taskbook Assessment data. The table has 21 fields. I would like to be able to update 6 of then with an Update query based on the data that is in them.

    From time to time we have to enter data on behalf of other people. Normally this is done through the normal Web access page and complete the assessment as if we were the assessor and then we will need to go through the admin menu and edit each record line by line. Time consuming.

    The fields involved in the query are Mentor 1 ID, Mentor 1 Date, Mentor 2 ID, Mentor 2 Date, Assessor ID, Assessor Date, Worker ID.

    I can easily do a query that will do Mentor 1 ID and Mentor 1 Date then a separate query for Mentor 2 and a 3rd query for Assessor.

    I can’t work out how to do an update query which will do the required data for all 3 at once.

    The problem is that there are 6 combinations which could happen and I only want the data updated for that specific combination.

    The combinations would be:
    Mentor 1
    Mentor 2
    Mentor 1 & Mentor 2
    Mentor 2 & Assessor
    Mentor 1, Mentor 2 & Assessor

    If someone was to “Sign” as Mentor 1 and Mentor 2 then that is the only related data I want changed

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2007
    Join Date
    May 2011
    The Great Land
    Will have to build decision code such as If Then ElseIf to select the appropriate criteria string for the UPDATE statement. Start the If with the sixth combination you show and work up the list. Whichever condition is met will return the needed string.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Update single record via forum, not entire table?
    By 10 Gauge in forum Programming
    Replies: 2
    Last Post: 02-11-2011, 09:14 AM
  2. Combining queries
    By wildlifeaccess in forum Queries
    Replies: 10
    Last Post: 09-20-2010, 07:35 AM
  3. Combining Two Queries
    By csolomon in forum Queries
    Replies: 1
    Last Post: 09-03-2009, 01:33 PM
  4. combining fields into a single list
    By rich in forum Queries
    Replies: 4
    Last Post: 02-23-2009, 06:41 AM
  5. Combining like update queries
    By xcr800man in forum Queries
    Replies: 2
    Last Post: 05-20-2008, 08:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums