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

Most Recent Contract 5
Join Query that needs more included 14
Summary query sum from different tables 15
Microsoft 365 Activations, Users or Devices? 0
SUMIF using date ranges & referencing account numbers 1
dcount in query 8
Link Items in Same Table 6
Query with most recent contract 2

Top