Query Question - Update Where [something] = 2 possible things

[SealM]

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

[SealM]

Wow, I let design view in Access take care of it, and it solved it for me. Here's what it pumped out in SQL:

UPDATE Raw SET Raw.call_on_weekend = "Call on Weekend, "
WHERE (((Format([date_of_call],"ddd"))="Sun" Or (Format([date_of_call],"ddd"))="Sat"));

Who woulda though! LOL. Ah well...