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)

Re: Past due query by John

John
Tue Sep 19 13:26:46 CDT 2006

No need to answer this. After beating the query for a while, it gave in and
now works.



"John" <Johna@nospam.nospam> wrote in message
news:OAUlfNA3GHA.4024@TK2MSFTNGP03.phx.gbl...
>
> 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)
>