How can I do a Query in ACCESS over a date range ?

Question

I am working on an Access database for work. I have never used it or any other relational database before and no one else at work has either.

I need to do a query that looks at orders over a date range and want to have the query ask for the dates when it is run.

How can I do this?

Answer 1

How can I do a Query in ACCESS over a date range?



You need a parameter query to prompt for two dates (beginning and end date) as the range.



In the criteria, you can set specify for the date field the following:



Between [Enter start date:] And [Enter End Date:]



Two prompt in the above order will require to valid and chronological dates to be entered typically in the format as dd/mm/yyyy.



See my article on Parameter Queries: http://www.about-access-databases.com/parameter-query.html



Also take a loom at setting criteria (date range) at http://www.about-access-databases.com/query-criteria.html



Hope this helped

Answer 2

Access Query Between Dates

Answer 3

This Site Might Help You.



RE:

How can I do a Query in ACCESS over a date range ?

I am working on an Access database for work. I have never used it or any other relational database before and no one else at work has either.



I need to do a query that looks at orders over a date range and want to have the query ask for the dates when it is run.



How can I do this?