Designing Parameter Query w/ Sum of QuantityOnOrder and ShipDate

[epete367]

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!

 

[John Vinson]

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.

Change the Group By on the Totals row under StartDate to Where. This
will include the start date only in the criteria, without grouping by
it.

John W. Vinson[MVP]