iif statements for a beginner

[bobby]

i would like to have a box on a report display the
contents of field a, if field b's contents equals field
c's contents.

ie, if b=c than display a. any suggestions? thanks in
advance.

 

[MacDermott]

You must specify not only what your box will display if b=c, but also what
it should display if b is not equal to c.

HTH
- Turtle

 

[bobby]

thanks for getting back. but where/how do i specify this
information to print out on a report?
bobby

 

[MacDermott]

The controlsource of your textbox.
Be sure to preface your IIF with =

HTH
- Turtle