I'm using Microsoft Access 97.

Question:

there's 70 records in Qry1 and 25 records in Qry2.
25 records in Qry2 are identical to the records in Qry1.

SQL Statement:
"select * from Qry1, Qry2 where Qry1.Field1<> Qry2.Field2"

It returns 1750 records instead of only 55 records. It seems like the <> statement is not working. Why?? How do i get the 45 records which is in Qry1 but not in Qry2??