Query to show record with duplicates once

tmyers

Well-known member
Local time
Yesterday, 21:47
Joined
Sep 8, 2020
Messages
1,091
I have a query that shows all jobs being worked on today and into the future ( > Date() -1). The problem I am having is when a job gets duplicated (for different versions or maybe a revision), the job shows up twice in this query, which I do not want.
Here is a snip of the design view:
Capture.PNG

However, the result is:
Capture.PNG

As you can see, the quote number 14763 has been revised once and is showing up twice. I would like it to only show up once with the max revision number, which in this case is 2.

What do I need to adjust to achieve that?
 
Hi. Your design view shows more columns than your result view. If you don't want duplicates, you'll have to minimize the columns you're grouping. Then, if you want additional columns after that, then you can create another query to join the Totals query with the table again.
 
also you can Remove BidDate as Column of your query but instead use it as Criteria Only (from Group By to Where)
 

Users who are viewing this thread

Back
Top Bottom