Duplicate Invoice Query

  • Thread starter Thread starter Newby to Access
  • Start date Start date
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.
 
"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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top