Find Duplicates Query

[ACDenver]

I am using the wizard to create the query criteria on finding duplicates in
an invoice table, and selecting on 3 fields(customer number, invoice number,
period of coverage) that can have duplicate records. My dilema now is that
there is a fourth field I would like to include in this query criteria on
where an absolute dollar value(original invoice) and a corresponding negative
value(credit memo invoice) offset to zero for these associated records. My
end result is to have an invoice table that removes these duplicate records
which represent original invoices offset by negative credit memos to have an
accurate frequency count.

Thank you.

 

[David S via AccessMonster.com]

I am using the wizard to create the query criteria on finding duplicates in
an invoice table, and selecting on 3 fields(customer number, invoice number,
period of coverage) that can have duplicate records. My dilema now is that
there is a fourth field I would like to include in this query criteria on
where an absolute dollar value(original invoice) and a corresponding negative
value(credit memo invoice) offset to zero for these associated records. My
end result is to have an invoice table that removes these duplicate records
which represent original invoices offset by negative credit memos to have an
accurate frequency count.

The simplest thing to do would be to use the Query Wizard to re-create the
Query and overwrite your existing query.

The other thing would could do is get into teh SQL and add the fourth field
manually, but it seems like more work than is necessary...