help with query

[BBurg859]

I'm fairly new to using Access. I have a query that needs to select a field that can have multiple values. Here is an example: The field in question can have "General", "Functional", "Test 1", "Test 2", or the field can be blank. I would like for my query to select "Functional" over the other values if it exists, otherwise select "General". If the value is blank, I would still need the query to return a blank value. Any help would be appreciated.

[June7]

Not sure what you want. You want only records with 'Functional' or Null unless 'Functional' is not in any records, then search for 'General'?

[BBurg859]

Sorry, I should have been more specific. I guess what I'm looking for is something like If "Functional" Then "General" Else "Is Null". But I'm not sure how to enter that in the Criteria. Order of priority is "Functional", "General", "Is Null".

[June7]

There is no 'prioritizing' filter criteria. A multi-criteria clause of " 'Functional' Or 'General' Or Is Null " will retrieve records that meet ANY one of those values, doesn't matter what order the valus are listed.