How To force a Null if Criteria doesn't exisit

[Jerseynjphillypa]

I have a the fields called Name, State and City in a table. The criteria I am filtering for is for "NJ" in [State], but if "NJ" is not in the table, I want the [City] to be "NA".

[redbull]

if (object)= "NJ" then
else
(object) = "NA"
end if

That seems to be the logic your trying to achieve.. if you have a bit of code I can look into it further.

[Jerseynjphillypa]

That's what I am looking for but don't know how to code it SQL.

Thanks for you help