Eliminate record if both field has the same value

[myaccess2000]

Hi,

I have make a query from a table. This sum up the total amount of money spend and total amount of money paid on item 1, into two field respectively.

item total spend total paid
1 1100 1100 <- Do not show on query.
2 1200 1100

How do i eliminate the record if both values are the same.
Pardon my little knowledge on access.

Regards
Irene

 

[danvlas]

Select * from YourTablename Where [Field1] <> [Field2];

or create a query and in the condition row for field 1, type:
<>[Field2]

Of course, you'll have to use the real field and table names.

Dan