Query ti list records that have been modified

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning

I want to create a query that will compare two table with the same structure to identify which records have been modified

Let say I have a first table with the folowing columns (Drawing ID -Can be listed many times,Start Date, End Date, Official's Name) and I have a second table with the exact same structure (just the data that may be different). How would I create a query that would verify which records have been change base on the first table

Thank you for your help

Daniel
 
Access has an Unmatched query wizard. Select F-11 and Query on the left, now
select New from the top of the object view screen. Then select the choice
Unmatched and follow the wizard.
HTH
Daniel P said:
Good morning,

I want to create a query that will compare two table with the same
Click to expand...
structure to identify which records have been modified.
Let say I have a first table with the folowing columns (Drawing ID -Can be
Click to expand...
listed many times,Start Date, End Date, Official's Name) and I have a second
table with the exact same structure (just the data that may be different).
How would I create a query that would verify which records have been change
base on the first table?
 
Back
Top