Not printing zero detail lines

[Guest]

In my report I have a calculated field that when it has a value of zero I do not want it to print or show up in preview
How do I do this?

 

[Allen Browne]

Presumably the calculated field is in a query, e.g.:
Due: [Debits] - [Credits]
If so, you can enter this into the Critieria row under your calculated
field:
<> 0

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

In my report I have a calculated field that when it has a value of zero I

do not want it to print or show up in preview.

 

[Guest]

I have two fields in a query [unitsin] [unitsout] but the calculation is done in the report, showing a current amount for a location. Currently it prints a product with an inventory amount of zero. I need it to not show or print if this value is zero

----- Allen Browne wrote: ----

Presumably the calculated field is in a query, e.g.
Due: [Debits] - [Credits
If so, you can enter this into the Critieria row under your calculate
field
<>

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.htm
Reply to group, rather than allenbrowne at mvps dot org

In my report I have a calculated field that when it has a value of zero

do not want it to print or show up in preview

 

[Allen Browne]

In the Criteria row of your query under [unitsout], enter:
<> [unitsin]

If unitsin or unitsout could be null, you will need to handle those cases as
well.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have two fields in a query [unitsin] [unitsout] but the calculation is

done in the report, showing a current amount for a location. Currently it
prints a product with an inventory amount of zero. I need it to not show or
print if this value is zero.

----- Allen Browne wrote: -----

Presumably the calculated field is in a query, e.g.:
Due: [Debits] - [Credits]
If so, you can enter this into the Critieria row under your calculated
field:
<> 0

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

In my report I have a calculated field that when it has a value of

zero I
do not want it to print or show up in preview.

How do I do this?