I have a simple query based on a table. There is one computed column as follows:

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:

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?

This post has been edited by ellenr: May 27 2011, 06:48 PM

I figured it out: If I change to IIf(len(Trim([origincountry]) & "") = 0,([city] & ", " & [state]),[origincountry]) it works.