I would like to (have been trying to) design a parameter query to build
a report.

The report will show ProductID, ProductName, UnitsInStock,
SumQuantityOnOrder along with a text box holding an IIf statement. This
is for a home-based dessert business db. The goal is to know, at any
given time, if there is enough product on hand to meet orders for the
product.

When I add the field StartDate to the query I then cannot SUM the # of
QuantityOnOrder. Each order shows as a seperate entry in the query.
When I leave off the field StartDate I can SUM the # of QuantityOnOrder
but cannot breakdown the report as needed to if product on hand meets
orders for a given time.

I tried creating a dialog form with txtStartDate and txtEndDate. On the
query in the field StartDate I used:
Between[Forms]![frmProductOnOrderDialog]![txtStartDate] And
[Forms]![frmProductOnOrderDialog]![txtEndDate]
However, I still don't SUM the needed field.

Any suggestions or assistance would be greatly appreciated. I have
looked at this all day (creating and deleting dozen of queries, forms
and reports) trying to make it work.

Thanks!