Comparing two tables
Posted on 2000-02-23
I am trying to compare two tables that contain balance sheet information. Each record from one table should match a record in the other table. (i.e. $500 in table1 should match a $500 in table2)The problems I am running into are:
1. There is not an equal number of records
2. There are sometimes a different number of equal entries (three entries of $500 in table1 compared to two entries of $500 in table2)
3. There are entries in each table that will not match up ($24 in table1, no such entry in table2)
I can write a query that gives me the entries that don't match up, but how do I get the equal amounts that don't match up. For example, if I have the three entries of $500 in table1 and only two in table2, how do I get Access to tell me that I have one entry of $500 in table2 that is out of balance.
Someone mentioned to me bookmarks, but I have never used them and I do not see how they would apply. Can I not just write a Query? Any help is appreciated.