Originally Posted by
Macallan60
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:
Code:
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???