Comparing 2 records in the same table

[whiterower]

Hi,
I have a table name tblmachines with mahineno,dateentered,meter1,meter2 and list fields. One user will enter the machineno and their meters as List A and the other as list B then after they enter all the machines acommand button is pressed that will compare both meter1 and meter2 of allmachines on from list A to List B on a particular date.

How will i do this?

 

[ghudson]

A good starting point would be to use the new query wizard and select the "Find Duplicates" or "Find Unmatched " option. That should point you in the right direction.

HTH

 

[whiterower]

I wanna show records that didnt matched from List A compared to List B..

 

[whiterower]

I wanna show records that didnt matched from List A compared to List B..ex machine 3 list A didnt matched with machine 3 in list B then will show the records.

Also im using access project i dont have Query object instead i have stored procedures