Show Day "Monday"

[klynch0803]

I'm trying to show the day in a query "monday or whatever the day s on correspondence to a date in the same query named "SALEDATE".

I have tried using several ways but cant figure it out.. Can someone please help me out here with a boost?

 

[KeithG]

lookup the Weekday and WeekdayName functions

 

[klynch0803]

You think since I'm using this on form it would process faster if I did this query as a strsql in the form versus using a query? I'm beggining to think so especially since its calculated based on selection of a checkbox..

 

[KenHigg]

WeekdayName(DatePart("w",[my date]))