Prev: delete button deletes the wrong thing
Next: Odd Error
From: Frank on 11 Feb 2010 13:36

"Frank" <fhsmith(a)cox.net> wrote in message news:...
> Hi John:
> Was able to get expression to work using the Nz expression. Thanks again
> for all of your assistance.
>
>
> "Frank" <fhsmith(a)cox.net> wrote in message
> news:iZFcn.48387$zN4.39188(a)newsfe05.iad...
>>I have a query that reflects a field named phonenumber on the main tale.
>>I want to replace all null values with "-----". my iif clause is as
>>follows:
>>
>> iif([phonenumber] is null, "----", [phonenumber]). When I run the query,
>> it returns all not null values. What am I doing wrong.
>>
>> Any assistance is greatly appreciated.
>>
>
>


First  |  Prev  | 
Pages: 1 2 3
Prev: delete button deletes the wrong thing
Next: Odd Error