Need expression Help on displaying value

  • Thread starter Thread starter lb
  • Start date Start date
L

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.
 
Can you show the IIf statement you are using and tell where you are using
it. In the report module or in the query?
 
You can probably use the Nz() function.
=Nz([Home Phone], [Cell Phone])

--
Duane Hookom
Microsoft Access MVP


Gina Whipp said:
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
lb said:
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.
Click to expand...
Click to expand...
 
Back
Top