I am having a slight problem with one of my queries. It is just a "history" query that shows all quotes starting from yesterday into the past. The problem is that a quote number can exist multiple times (the JobID however is still unique to each one). When a quote number shows up multiple times, there are different "packages" for that quote. For the purposes of this query however, I need to only show it once. How can I get that to happen?
As you can see, one is showing up twice. Can I somehow drill it down to only show a given quote number once?
Here is the current SQL behind the query:
As you can see, one is showing up twice. Can I somehow drill it down to only show a given quote number once?
Here is the current SQL behind the query:
SQL:
SELECT DISTINCT First(tblJobDetails.QuoteNum) AS FirstOfQuoteNum, tblJobDetails.JobName, tblJobDetails.BidDate, tblUsers.FirstName, tblJobDetails.CompletedDate, tblJobDetails.JobAwarded, tblJobDetails.JobLost
FROM tblUsers INNER JOIN tblJobDetails ON tblUsers.UserID = tblJobDetails.UserID
GROUP BY tblJobDetails.JobName, tblJobDetails.BidDate, tblUsers.FirstName, tblJobDetails.CompletedDate, tblJobDetails.JobAwarded, tblJobDetails.JobLost
HAVING (((tblJobDetails.BidDate)<Date()));