Simple iif question

[Sam H]

Hi Peepz,
I am having problems with an IIF statement in the field
[Cusip] in my Query. I want to show "19810704" is there is
no cusip number in the Bookcredit table.

IIf(([BookCredit].[Cusip]) Is Null, ([BookCredit].[Cusip])
= "19810704",([BookCredit].[Cusip]))

Thanks,
sam

 

[Jim Jawn]

Sam:

Close, but No Cigar...

Nz([BookCredit].[Cusip], '19810704')

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaac10/html/acmthNz.asp

use the Nz Function

 

[Fredg]

Sam,
NewField:IIf (IsNull(Cusip]),"19810704",[Cusip])