Difficult Query

[NJudson]

Or at least it's diffucult for me. Anyway, I'm using Access2k and I wrote a query that is comparing 2 tables. The tables have 11 Fields. The first table is the raw data table and the second table is the Master data table and I want to find and discrepancies between the tables and display the record that has any discrepancies. My query does just fine. It will display the record that contains a mismatched field but I want it to not only display the record but identify which field was incorrect. I've attached an excel file to better explain what I'm having trouble with. I hope that I have been clear enough on my problem. Thanks.

 

[namliam]

In order for you to compare the 2 records you will need to have a Primary Key in your table....

Assuming Field1 is your PK, try attached texfile

Regards

 

[NJudson]

Thanks so much, I'm incorporating your suggestions and I need to modify it a little but so far its looking good. I never used the IIF statement before and it certainly looks very useful. If I have any problems I'll report back but its looking good so far. Thanks again.