Duplicate Invoice Query

N

Newby to Access

I am attempting to query a table to filter the invoice field for duplicate
numbers. I am also attempting to filter the payment amount for duplicate
payments.

I appreciate any assistance in building the expression for the criteria
field.
 
J

Jeff Boyce

"How" will depend on "what" ... what data you are keeping, in what data
structure.

Generically, though, consider using the create query wizard and selecting
the "duplicates" query. Access will build most of it for you if you can
tell it what might be "duplicated".

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top