criteria mismatch

[Guest]

I ran an IIF expression to change certain values in another column into text
for grouping purposes. Specifically I have zip codes in one column and I have
an IIF expression to convert them into the names of the county that the zip
codes are in. I want to be able to sort the data so that I can view all of
the items in the same county together, but I keep getting a "data mismatch in
criteria" alert. Also, if I try to simply sort the data, it asks me to input
parameter data from the zip code column. I can't do all of this in one single
column because I already had to do extensive TRIM functions to get the zip
codes as they originally came from a column that had data in many forms.
Anyway, if you know of any way to solve this it would be much appreciated.
Also, if you are going to ask for the code, please tell me how to get it so
that I can copy it for you. Thanks

 

[pietlinden]

Not without the actual query SQL

Sorry, psychics are off today. We need more info.

 

[Guest]

I would just write a second query that uses the first one you mentioned
instead of the table. You should be able to filter and sort in the new query.