If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Duplicate Invoice Query
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. |
#2
|
|||
|
|||
Duplicate Invoice Query
"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 "Newby to Access" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|