Sometimes you need the actual day name of the date and not the numeric equivalent, the following function will do that for you:

Example use in debugger window:

ADVERTISING
MS Access Consulting

?MyWeekDayName(#10/19/2009#)

Monday