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!

 

[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.