I'm working with a very large file that has negative and positive
amounts (credits & invoices). I'm looking to find credits for a
customer that equally match outstanding invoices for the same customer
and isolate them.

Ex. - A credit for ($135.62) and an invoice for $135.62 for the same
customer should appear in the same found set. I would be searching all
customers and records at the same time.

So far, I created a field that calculates both as positive numbers. I
query for '!' in the amount of this field. This brings in loads of
others invoices and credits that don't match 'credit to invoice'.
Duplicates of matching credit amounts and matching invoices also end
up in the found set.

Does anyone know how I can make things more selective? Any help would
be appreciated.

Thanks...JohnB

You could limit by the customer/vendor (not knowing if this is AR or
AP). That will get you to a smaller set.
TK

On May 17, 5:39 pm, JohnB <bile... (AT) excite (DOT) com> wrote: