If statement in reports

[qbc]

Hi,
I am wondering if it is possible to create the following in a text box in reports.



I would like the software to take a look at one field and return a value in a new field based on the first field.

for example,
if field agency is 1 then enter CAD

anyone know how to do this?

thanks

[pbaldy]

Check out the IIf() and Switch() functions. The first for a choice or two, the second for any more. You might also consider a table with the two values, enabling you to join that table and return the CAD value as one of the available fields for your report.