Need expression Help on displaying value

[lb]

I have tried IIF and can't seem to get anything but ERROR. If [home phone]
is null, I need the value of [cell phone] displayed on the report. I cannot
find anything anywhere that helps.

 

[Gina Whipp]

Can you show the IIf statement you are using and tell where you are using
it. In the report module or in the query?

 

[Duane Hookom]

You can probably use the Nz() function.
=Nz([Home Phone], [Cell Phone])

--
Duane Hookom
Microsoft Access MVP

Can you show the IIf statement you are using and tell where you are using
it. In the report module or in the query?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

I have tried IIF and can't seem to get anything but ERROR. If [home phone]
is null, I need the value of [cell phone] displayed on the report. I
cannot
find anything anywhere that helps.