Using IIf Statement for Empty Or Selected Data 1

[awl]

My goal is to have the [Job#] field in my query to display the number 240 if the field [Job] is blank, OR if the number is 0. In my query I have the following formula which works for blank data entries. However, I can not get those [Job] fields with a 0 to be converted to the number 240. I have tried several other formulas for the second half but with no luck. Your help would be appreciated. Thank you. Curtis....

JOB#: IIf(IsNull([Job])=False,[Job],240)

 

[PaulBricker]

Try this

IIf(IsNull([Job]) or [Job] = 0,240, [Job])



Paul

 

[awl]

Paul, thanks very much. I have other fields in the same query that this issue will apply. Thanks again. Curtis....