Query to show record with duplicates once (1 Viewer)

tmyers

Active member
Local time
Today, 11:48
Joined
Sep 8, 2020
Messages
700
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?
 

theDBguy

I’m here to help
Staff member
Local time
Today, 08:48
Joined
Oct 29, 2018
Messages
16,612
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.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 23:48
Joined
May 7, 2009
Messages
14,176
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

Top Bottom