Search results

Dr. B, The query you gave me did not provide a distinct count of pos, but you lead me down the right path. This is what I did and I validated the data to be correct. First Query called qry_POGreaterThan2500... SELECT PO_Num, VendorName, SUM(AmountDC) AS PO_Total FROM Cons_Data Group By...

I took a look at query 1 and I think we're getting closer. The problem with this query is that it is returning ABC twice. What I need it to return is: ABC, 2 BAC, 1 I tried this: SELECT B.VendorName AS Vendor, Count(B.PO_Num) AS Number_Of_POs FROM (SELECT DISTINCT PO_Num, VendorName FROM...

Thank you both for the quick response, but Dr. B this did not return a count of distinct purchase orders. It counted orders multiple times. It also did not sum the amount fields to ensure that they totalled more than $2500. Any thoughts on how I can modify this to ensure I'm only getting a...

I wrote the query below, but it's taking over an hour to complete. I understand that access does not have the count(distinct x) function, so I was lead down this path. Any idea if this is wrong or if I can improve its performance. Any assistance would be greatly appreciated. The table looks...