Totals query not working

[din2005]

I'm trying to do totals query where it adds the prices in the inclVAT. This works but soon as i have a criteria between certain dates i get this error message...

"You tried to execute a query that does not include the specified expression tblpreorder.reqdate Between #1/1/2002 and #31/12/2002# as part of the aggregate funciton"

SELECT tblPreOrder.FinanceCode, Sum(tblPreOrder.IncLVAT) AS SumOfIncLVAT
FROM tblPreOrder
GROUP BY tblPreOrder.FinanceCode
HAVING (((tblPreOrder.ReqDate) Between #1/1/2002# And #31/12/2002#));


Is there anyway of solving this one or trying to do it a different way???

 

[PHV]

SELECT FinanceCode, Sum(IncLVAT) AS SumOfIncLVAT
FROM tblPreOrder
WHERE ReqDate Between #2002-01-01# And #2002-12-31#
GROUP BY FinanceCode

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886