myaccess2000
Technical User
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
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