Dears,

I m using the following Query which gives the required data
SELECT Sale_Main.SaleDate, Sum(Sale_Detail.Qty) AS SumOfQty
FROM Sale_Main INNER JOIN Sale_Detail ON Sale_Main.SaleId = Sale_Detail.SaleId
GROUP BY Sale_Main.SaleDate, Sale_Detail.Qty

But when i use it with SELECT Sale_Main.SaleDate, Sum(Sale_Detail.Qty) AS SumOfQty FROM Sale_Main INNER JOIN Sale_Detail ON Sale_Main.SaleId = Sale_Detail.SaleId GROUP BY Sale_Main.SaleDate, Sale_Detail.Qty
HAVING (((Sale_Main.SaleDate)<[?])) it gives nothing... is something wronh in this Query ?? Please help