Finding Unmatched Rows

[antmorano]

I am trying to create a find unmatched query in access 2000. I have a
table that has values for months 1-12. I want the query to look at
the value in one table that I have an compare them to the values table
that I created. If the value don't match up then I want a query
created which shows those records. I am having a lot of trouble
figuring this out. Any input would be greatly appreciated.

-Anthony Morano
Pension Intern

 

[John Spencer]

So does your table structure have a column for each month? Or do you have a
table structure where the month is identified in ONE field and the Value
associated with the month is identified in a second field?

How do you match row 17 in one table with row 283 in the other table? Is
there a primary key field (a field or fields with unique values) that you
can use to match the records between the two tables?

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Guest]

It sounds like you have a table structure that is a spreadsheet. What are
your field names and datatype?