From: IIf(Trim([origincountry]) Is Null,([city] & ", " & [state]),[origincountry])
When I open the query, it displays the "From" column correctly, with a city and state or a foreign city for each record in the query. I have a report linked to this query. The column "From" Intermittently fails to print the value--it randomly prints about a third of the cities. I tried setting the properties data source for the From variable from "from" to:
= IIf(Trim([origincountry]) Is Null,([city] & ", " & [state]),[origincountry])
and the report returned #Error for all records. There is no conditional formatting on that column. I simply cannot find anything that sets apart the records that print correctly and those that don't. I must be missing something simple. Any ideas?