Set criteria between two dates

[tjnichols]

Hello - I would like my query to select only the records between two dates. This query should ask the user the dates before the query is invoked. This is the code I have but it only asks for one date. I need both. >[EnterDate] And <[EnterDate]

I have also attached the database.

Thanks!

 

[Mr. B]

As with many things in MS Access, there are multiple ways to accomplish this.

Take a look a this link:
http://office.microsoft.com/en-us/a...o-make-a-query-ask-for-input-HA010341833.aspx

It will get you started if you just want the query to just prompt the user for the parameters and then return the results.

If you are building an application, normally, you would create a form with controls that will provide the opportunity for the user to provide the parameters for the query. The criteria in the query would be a reference to the controls on the form that contain the parameter values.

 

[Brianwarnock]

The point is that the poster has only asked for one parameter EnterDate, he needs two

EnterStartDate and EnterEndDate

Brian