re Iff function

[Anne]

I have a report that displays inventory that we have in stock. The "Quantity
on Hand" is determined in a subform calculation. I would like to add an Iff
statement that says if the quantity on hand = 0 do not display the record.
For instance I have a lot of lines with discontinued stock items that are
just adding lines to the report and showing 0 value.

 

[KARL DEWEY]

Just use criteria >0 for inventory qunaity on hand.

 

[Anne]

This is the calculation that runs on my embedded subreport
=Sum(nz([UnitsReceived])-nz([UnitsShrinkage])-nz([UnitsSold]))

The "quantity on hand" control is from this field in the main report is
called called "Units on Hand" This is the control for that field.
=[Inventory Transactions].Report!UnitsOnHand

I'm not sure where to put the "criteria >0 for inventory qunaity on hand"

Thanks

 

[KARL DEWEY]

I assumed that your subreport source was a query and the criteria would be
there.

This is the calculation that runs on my embedded subreport
=Sum(nz([UnitsReceived])-nz([UnitsShrinkage])-nz([UnitsSold]))

The "quantity on hand" control is from this field in the main report is
called called "Units on Hand" This is the control for that field.
=[Inventory Transactions].Report!UnitsOnHand

I'm not sure where to put the "criteria >0 for inventory qunaity on hand"

Thanks
--
Anne

Just use criteria >0 for inventory qunaity on hand.

 

[Anne]

Is there another way I can stop the "0" Quantity on Hand records from
displaying in my report?

Thanks
--
Anne

I assumed that your subreport source was a query and the criteria would be
there.

This is the calculation that runs on my embedded subreport
=Sum(nz([UnitsReceived])-nz([UnitsShrinkage])-nz([UnitsSold]))

The "quantity on hand" control is from this field in the main report is
called called "Units on Hand" This is the control for that field.
=[Inventory Transactions].Report!UnitsOnHand

I'm not sure where to put the "criteria >0 for inventory qunaity on hand"

Thanks
--
Anne

Just use criteria >0 for inventory qunaity on hand.

:

I have a report that displays inventory that we have in stock. The "Quantity
on Hand" is determined in a subform calculation. I would like to add an Iff
statement that says if the quantity on hand = 0 do not display the record.
For instance I have a lot of lines with discontinued stock items that are
just adding lines to the report and showing 0 value.

 

[KARL DEWEY]

I do not know of another way than in a query.
Perhaps someone else may.

Is there another way I can stop the "0" Quantity on Hand records from
displaying in my report?

Thanks
--
Anne

I assumed that your subreport source was a query and the criteria would be
there.

This is the calculation that runs on my embedded subreport
=Sum(nz([UnitsReceived])-nz([UnitsShrinkage])-nz([UnitsSold]))

The "quantity on hand" control is from this field in the main report is
called called "Units on Hand" This is the control for that field.
=[Inventory Transactions].Report!UnitsOnHand

I'm not sure where to put the "criteria >0 for inventory qunaity on hand"

Thanks
--
Anne


:

Just use criteria >0 for inventory qunaity on hand.

:

I have a report that displays inventory that we have in stock. The "Quantity
on Hand" is determined in a subform calculation. I would like to add an Iff
statement that says if the quantity on hand = 0 do not display the record.
For instance I have a lot of lines with discontinued stock items that are
just adding lines to the report and showing 0 value.