Switch Function

[Macallan60]

Hello,



I need some help with a switch function. I have heard this was better to use than nested IIf functions. Attached is a example database. My switch function in the a new field named "Loc" in the selWIP_Download query. It works great. However, for all the records that are null in my query, I want to use the value that is in the "Status" field. Any help is appreciated.

I hope this makes sense.

Thank youExample.accdb

[June7]

Advise not to use spaces in naming convention.

Just add one more condition in the Switch at the end: True, [Status]. Any record not matching the other conditions will pull from Status

One record (Status Flag 30) does not have any data.

[ssanfu]

However, for all the records that are null in my query, I want to use the value that is in the "Status" field. Any help is appreciated.

Whaaaat?
Where the whole record is Null? OR specific Fields are NULL? Or one specific Field is NULL?

Something like this?

In your query, I moved the [Checker ID] column to be in the same place as in the table to make it easier to compare the results between the table and the 2 queries.

I guessed that if [Checker ID] is NULL, you wanted to see the value from [Status] in the [Loc} column.
So I created another query (Query1) using this SQL:

SELECT tblWIP_Download.[Status Flag], tblWIP_Download.[Checker ID], Switch([Status Flag] In ('10') And [Checker ID] Is Not Null,"Embroidered, Not Complete", [Status Flag] In ('10') And [Checker ID] Is Null,"Not Started", [Status Flag] In ('20','25','60'),"Complete", [Status Flag] In ('00','05'),"Not Started",
 [Checker ID] Is Null,[Status]) AS Loc FROM tblWIP_Download;

Is this close???

[Macallan60]

Thank you both for your suggestions. Works perfectly!

June7 - I'll get to work on removing those spaces. Thanks again.