Hi,
I created access report with the field in my report displaying 1,2 and 3 as values. How can I modify the report to display the following instead?
If value= 1 show “closed on site”
IF value 2 show “closed off site” etc.
TIA
Regards,
Hi,
I created access report with the field in my report displaying 1,2 and 3 as values. How can I modify the report to display the following instead?
If value= 1 show “closed on site”
IF value 2 show “closed off site” etc.
TIA
Regards,
Most flexible is having a table with the values in two fields, and join to that table in the report's source query. You can hard-code it with the Switch() function or nested IIf() functions.
Paul,
Thanks, it is working now. The nested IIF( ) function did the trick.
Regards,