simple iif syntax

[shafh]

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

 

[Jon K]

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


I am assuming Cusip is a text field.