MS Access Query help, querying for certain days between 2 dates.
Posted on 2009-07-14
I have a query in Access that queries Oracle tables and pulls data based on a specified date range...start date and end date. What I would like to be able to do, without using VBA if possible, is to use the query I currently have to pull data for a date range, but specify only certain weekdays that I want, i.e Mon-Thur.
So when a user enters a start date and an end date, the query will return data between those dates for Monday through Thursday only. Is this possible? If not I will just write the VBA code to do it instead...thanks.