Deleting Records Which Sum to Zero

  • Thread starter Mohammad A. Zaky
  • Start date
M

Mohammad A. Zaky

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
 
J

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
Click to expand...

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]
 
Top