L
l_bax
I have based an Inventory Control database on the MS Access Inventory
Control template. Everything works fine. I need to build a report
that will display the ReorderQuanity if the Units In Stock are below
the ReOrderLevel. I have a query that has two tables (Products and
Inventory Transactions) linked by the primary key ProductID
Field Table Total
ProductID Products GroupBy
ProductName Products Groupby
ReorderLevel Products GroupBy
ReOrderQuanity Products GroupBy
UnitsInStock Expression
Sum(nz([UnitsReceived])-nz([UnitsSold])-
nz([UnitsShrinkage])
Ive tried adding a new expression ReOrder: IIf ([UnitsInStock] <
[ReorderLevel]), [ReOrderQuantity], 0 ). This expression works except
the it keeps asking me to in a parameter in the UnitInStock. If I
enter nothing, then the query runs just fine. Any suggestions? I know
very litte about programming VBA.
Control template. Everything works fine. I need to build a report
that will display the ReorderQuanity if the Units In Stock are below
the ReOrderLevel. I have a query that has two tables (Products and
Inventory Transactions) linked by the primary key ProductID
Field Table Total
ProductID Products GroupBy
ProductName Products Groupby
ReorderLevel Products GroupBy
ReOrderQuanity Products GroupBy
UnitsInStock Expression
Sum(nz([UnitsReceived])-nz([UnitsSold])-
nz([UnitsShrinkage])
Ive tried adding a new expression ReOrder: IIf ([UnitsInStock] <
[ReorderLevel]), [ReOrderQuantity], 0 ). This expression works except
the it keeps asking me to in a parameter in the UnitInStock. If I
enter nothing, then the query runs just fine. Any suggestions? I know
very litte about programming VBA.