Results 1 to 3 of 3
  1. #1
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23

    How to see what table an update query is updating?


    I'm working inside a 2010 Access database I didn't build and I'm poking around an update query that is updating... something. I just don't see listed precisely what it is updating. Presumably that info is stored somewhere: can someone tell me where to find it?

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Post the SQL code of the query. If you are in designer it should show you right there which fields it is updating.

  3. #3
    Ceichhorn is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Feb 2017
    Posts
    23
    Thanks Bulzie, that got it!

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

Similar Threads

  1. update query not updating table
    By ui7598h in forum Queries
    Replies: 2
    Last Post: 03-28-2015, 07:49 PM
  2. Update Query returning more records than table it is updating
    By frustratedwithaccess in forum Queries
    Replies: 4
    Last Post: 02-07-2015, 04:20 PM
  3. Replies: 12
    Last Post: 11-11-2014, 02:10 PM
  4. Replies: 6
    Last Post: 04-03-2014, 02:02 PM
  5. Replies: 6
    Last Post: 05-10-2012, 08:20 PM

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