Bung ,
Without the specifics try this:
Table 1
id, field2, field3
Table 2
id, field2, field3
create a query using the Query Builder, use both tables and link them
together by ID. (I assume you know how to do this bit), select field2
and field3 from Table 1 and drop them into the fields area of the
query builder.
in the first row of the criteria on field2 type:
<>[Table 2].field2
on the next row of the criteria on field3 type:
<>[table 2].field3
repeat this process for each field moving to the next row of the
criteria.
This creates the following sql
SELECT [Table 1].id, [Table 1].field2, [Table 1].field3
FROM [Table 1] INNER JOIN [Table 2] ON [Table 1].id = [Table 2].id
WHERE ((([Table 1].field2)<>[Table 2].[field2])) OR ((([Table
1].field3)<>[Table 2].[field3]));
To see how this works, try creating two tables (Table 1 and Table 2)
with the three fields and make the values in the non key fields
different. Run the query and see what happens. Try adding a field to
each table and adding them to the query. You should see how you can
do this for as many fields as you need.
Hope this helps
:)
bu**@telusplanet.net (Bung) wrote in message news:<b8*************************@posting.google.c om>...
Hi,
I am not really familiar with MS ACCESS. However, I am trying to make
some reports where you compare current data from a table with old data
from the same table. What I'm saying is we have a database with
current data, and the same database with old data.
I need to create reports for new rows inserted, deleted rows, and
updates rows. I'm having trouble figuring how to query which rows
have been updated (meaning the primary key(s) are the same, but other
attributes of the row have been modified).
Can someone please help?
Bung