access 2003 report - simple I think

  • Thread starter Thread starter linda b
  • Start date Start date
L

linda b

I am doing a report. Given the contents of one
field "Individual total" I want to do 2 things. If it
is "0" I want to print a message and go on to the next
record and the next page. If it is not "0" then I have a
series of lines to print.

I think this is simple but it has bee a few years since I
have done any of this and the helps are just not getting
me there.

Any guidance would be appreciated

Linda
 
Use an IIF statement:
=IIF([Individual total]=0,"Text for zero","Text for not
zero")
If there is a possibility of null vs. zero;
=IIF([Individual total]=0,"Text for zero",IIF([Individual
total] is null,"Text for null","Text for not zero"))
Hope this helps.
Fons
 
Back
Top