Sorting based on a date range

[woknick]

I have a table with ProductID, Quantity, and DateUsed

I want to pull out the total number of products for a specific date range.


Here is the query I have so far

SELECT Count([InventoryTrack].[Quantity]) AS Total
FROM InventoryTrack
WHERE ([InventoryTrack].[Productid]="110");

The output is 14
This output is the total amount in the table. I would like to add a date sort to pull out all from last month.

I hope this makes sense.

Thanks in advance

 

[pdx_man]

SELECT Count([InventoryTrack].[Quantity]) AS Total,
SUM([InventoryTrack].[Quantity]) AS QuantTotal Something to add, maybe
FROM InventoryTrack
WHERE ([InventoryTrack].[Productid]="110")
AND [InventoryTrack].[DateUsed] Between #09/01/04# AND #09/30/04##;