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
 

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

Similar Threads

How to find duplicate payments 12
Duplicate Query between dates 2
Queries 2
DupliciteRecords 1
Duplicate query 3
query question 4
Customer Query 1
Append duplicate invoice numbers 1

Top