G
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?
How do I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
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.
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.
do not want it to print or show up in preview.Kevin Fitz said:In my report I have a calculated field that when it has a value of zero I
G
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
----- 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
do not want it to print or show up in previewKevin Fitz said:In my report I have a calculated field that when it has a value of zero
A
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.
prints a product with an inventory amount of zero. I need it to not show or
print if this value is zero.
<> [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.
done in the report, showing a current amount for a location. Currently itK Fitz said:I have two fields in a query [unitsin] [unitsout] but the calculation is
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.
zero IKevin Fitz said:In my report I have a calculated field that when it has a value of
do not want it to print or show up in preview.How do I do this?