Deleting Records Which Sum to Zero

[Guest]

How do I remove all the records which have the sum of zero from an access
table?

If I have some records as follows:

F1 F2 F3 Amt
199 200 201 100
199 200 201 -100
199 200 201 500
I want to pull out the first two record because their sum equal to zero.

Thanks

 

[John Vinson]

On Wed, 4 May 2005 04:15:02 -0700, "Mohammad A. Zaky" <Mohammad A.

How do I remove all the records which have the sum of zero from an access
table?

If I have some records as follows:

F1 F2 F3 Amt
199 200 201 100
199 200 201 -100
199 200 201 500
I want to pull out the first two record because their sum equal to zero.

Thanks

And if you have 31228 records do you want to compare every possible
combination? That might take a while!

I see some other fields - if you had a record

F1 F2 F3 Amt
199 345 224 -100

should it be deleted (it sums to zero with your first record)?

More details please!

John W. Vinson[MVP]