Chosing dates for report

[uttwo]

Hi,

I need item name, total quantity sold, total quantitiy delivered.

I need some thing that lets me put in two dates, the start date and end date.

Th Sql code for some reason dont' not give me the right result. It must be wrong!!! Help me fix it!!!


SELECT DeliveryAA.itemnameAA, Sum(DeliveryAA.delqtyAA) AS SumOfdelqtyAA, Sum(ItemSaleAA.saleqtyAA) AS SumOfsaleqtyAA, DeliveryAA.timedateAA
FROM SupplierAA INNER JOIN (SaleAA INNER JOIN ((DepartmentAA INNER JOIN DeliveryAA ON DepartmentAA.deptnameAA = DeliveryAA.deptnameAA) INNER JOIN ItemSaleAA ON DepartmentAA.deptnameAA = ItemSaleAA.deptnameAA) ON SaleAA.salenoAA = ItemSaleAA.salenoAA) ON SupplierAA.splnoAA = DeliveryAA.splnoAA
GROUP BY DeliveryAA.itemnameAA, DeliveryAA.timedateAA
HAVING (((DeliveryAA.timedateAA) Between #1/1/2004# And #12/31/2004#));

 

[tpeter]

Can't you load in the criteria of the date field between>=[Enter Start Date] and<=[Enter End Date]

 

[uttwo]

i tried that it gives me a blank table.

 

[tpeter]

WHERE (((tblprojectnumber.Date) Between [Enter Start Date] And [Enter End Date]) AND ((tblprojectnumberadditions.Date)>=[Enter Start Date] And (tblprojectnumberadditions.Date)<=[Enter End Date]));

This is a sql that I have to sort by date it is 2 tables but It might help