Acess Query Help

[ndyszelski]

Hey guys,

I am have two different tables. One table contains data for an update I ran and the second table contains the new data after the update. I would like to write a query that only shows data that has been updated and that is different from the data in table 1. Help please.

[Scott Price]

Hey guys,

I am have two different tables. One table contains data for an update I ran and the second table contains the new data after the update. I would like to write a query that only shows data that has been updated and that is different from the data in table 1. Help please.

You should probably rewrite your update query to only update the records that need updating, because that would certainly erase the need to go looking for records that have been added to the updated table needlessly.

Otherwise, you can write a select query that contains the WHERE criteria [tblbeforeupdate].[fieldx] <> [tblafterupdate].[fieldx]

Regards,
Scott

[ajetrumpet]

This is what append queries are used for. See what you can get from the query design grid when you select append query. You can also set this up to run automatically if you have to append records to another table more than once.