Date Format

[Mich76]

I would like to report on a specific days of the week i.e. Mon-Fri and Sat-Sun. Is this something I can do in my access query?

Thank


Michelle

 

[Mr. B]

Yes, Michelle, you need to create a new column that will result in the Weekday value so you can then use that field for your criteria.

In a new column of the QBE, copy and paste the following:

Day: DatePart("w",[TableNameHere]![DateFieldNameHere])

Change the "TableNameHere" and "DateFieldNameHere" appropriately of course.

This will return the number of the day of the week for each date. You can restrict the values return to specific days by adding the desired weekday number as your criteria.

 

[Mich76]

Mr B.

Thank you.

Michelle