Hi everyone!
Easy question, but it's tripped me up a bit, I'm sure most everyone knows how to do this, I must have a brain block today.
I have a simple query that is updating a field with text, if the day of the week is on a weekend. I can get it to work if I add just ONE day, but I want it to work if it is either of saturday or sunday. Here's what I got...
(call_on_weekend) is a field I'm just updating the text to, and (date_of_call) is a date field I need to know if it occurred on a weekend:
UPDATE Raw SET Raw.call_on_weekend = "Call on Weekend, "
WHERE format([date_of_call],"ddd")="Sun";
If I put: ="Sun" or "Sat"; at the end, it does not work. and it won't let me use: =In(Sat,Sun) which would be my preference/experience. So how do I make that last WHERE command pick both saturday and sunday? Thanks in advance for the help!
Mikel