Query to Pull Data for Specific Day of the Week

[KEKeogh]

This is probably a real simple formula but what I want to is to have a query that each column is data for day of the week.

Example

Column 1 pulls anything that happened on a Monday for June 2011 would include anything on 6/6/11, 6/13/11, 6/20/11, and 6/27/11.

Column 2 pulls anything that happened on a Tuesday for June 2011 would include anything on 6/7/11, 6/14/11, 6/21/11, and 6/28/11.

And so forth.

Is there an expression I can put in a query for this? I'm a very basic Access 2000 user.

Thanks
Kathie

 

[Brianwarnock]

lookup Weekday in help, probably in VBA help but you can use it in a query.

Brian