If value is zero use county name

[dhborchardt]

I have data where some of the zip codes are not given. In that case I need to go by the county name which is another field in the record. Can I just use some sort of If then expression?
ZIPCODE: If [zipcode] = 0 then [CountyName] else [zipcode].


Sorry Access query expressions are not my strong suit.
Thanks

[June7]

IIf([zipcode]=0,[CountyName],[zipcode])

Does the field have a 0 value? Or is it actually Null?

Nz([zipcode],[CountyName])

[dhborchardt]

I am getting #Error on all zip codes regardless of 0 or actual zipcode. I could give you a screen shot showing the query, the result and the table that is being queried but I don't see how to attach.

Your second question: The original data came in a text file with the word Null. I am guessing that would be handled as text so I did a replace all and used 0.

[June7]

Attachment manager is below the Advanced Post editor. Click Go Advanced below the Quick Reply editor.

Where did you use the expression?

[dhborchardt]

I figured it out. The 0 is text so I added "s.
IIf([zipcode]="0",[CountyName],[zipcode])
Thanks again.

[June7]

Of course, I should have realized that. Glad you figured it out.