Writing a Query based on Day of Week

From: Alan Balthrop (no_at_spam.none)
Date: 02/29/04 

Date: Sun, 29 Feb 2004 11:01:59 -0600

Is it possible to write a query that looks for data on a specific day
of the week? I assume I would need to have the date in "long format"
(ie. Sun, February 29, 2004).

The query I want to write is what is a soccer team's won-loss record
on a paticular day of the week. Is Access 2K2 smart enough to know
that 2/29/2004 is a Sunday without it seeing "Sunday" in the field?

Alan Balthrop