Past due query

  • Thread starter Thread starter John
  • Start date Start date
J

John

I am trying to create a past due query of active quotes but instead of
giving me a sum, it gives me multiple sums all equal to 1. I assume it is
due to the "group by" being different but it won't let me do the query
without it. What am I doing wrong?

SELECT COUNT(QuoteDueDate) AS Expr1
FROM Quotes
GROUP BY QuoteDueDate
HAVING (QuoteDueDate < @Date)
 
Back
Top