Duplicates in QUery

K

Karissa

I'm running a query comparing tickets to contracts...they're connected by
account numbers. So, one account number can have more than one contract.
Because of this, when I run the query, ticket #1234 may have 3 matches...I
want to just use the most recent contract and not even see the
others...ummm...help? I've tried doing a max on the contract date, but
that's not working.
 
K

KARL DEWEY

Create a totals query with contract and max on the contract date. Save.
Use it in another query joined on contract and contract date.
 

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

Summary query sum from different tables 15
Need Help soon with this querry!!!!!! PLZ PLZ 0
Join Query that needs more included 14
DMAX in query - get record with latest date by vendor 5
dcount in query 8
Numbering Raws 5
Query to remove mult. lines in table 3
Creating a "grid" of data 3

Top