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?

lookup the Weekday and WeekdayName functions

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..

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