Parameter Query with date Ranges

[cnut1]

I am attempting to create a parameter query to show a specific range of dates of service for my customers. Example: I want to see data from my table from Jan. 1st, 2006 to Feb. 15th, 2006 for any customers serviced in that time frame. In the query I have under my Date field, I have the following in the criteria field: Between [Input Start Date] And [Input End Date]. When I go to the while in the design mode of creating the query on the main menu under Query then to parameters and get my Query Parameters what should be put into the Parameter column and the data type columns and will this allow the user to input any start date and end date and get the information from the master table?

I also need to create a parameter query that will allow viewing of only each months table data. Example: Jan. 1st, 2006 through Jan. 31st, 2006.

Thanks in advance!

 

[Uncle Gizmo]

Form to Return between clause
Between clause.

There is an example form here, that will provide you with the between Clause for a query. This method is different than the way you are doing it, and it may not suit you. However you may like to consider it.

 

[oscarooko]

Hello

A select statement i this line should help . I used it in a similar problem, and it worked just fine.

SELECT CustomerName, date
FROM tableName
WHERE date >[Input start date] AND date <[Input End Date];


I assumned that the table is called tableName and that you need to view the CustomerNames and the dates of service between the beginning and end dates that are input by the user.