PDA

View Full Version : If statement for NULL field in Report



lynn_victoria
05-13-2005, 10:50 AM
I have a report that has a control on it called CompanyName, in 2 records, this field is blank, because it has not been sold; I am trying to do something like this: (unsuccessfully I might add! LOL)


=IIf([CompanyName]="","Not Sold",[CompanyName])

Thanks!

lynn_victoria
05-13-2005, 01:37 PM
Ok i am the dumbest thing going:


=IIf(IsNull([RegistrationFee]), "Not Sold" ,[CompanyName])

is the proper statement

Norie
05-13-2005, 01:42 PM
Or


=Nz([CompanyName], "Not Sold")