How Do I Get A Calendar Into A Query Parameter

[James Parker]

I wrote a query which prompts entry of a start date and an end date, thus the user has to type into the parameter box. The date field is called When, and the table is called Scrap_Q4. Here is the SQL language

SELECT Scrap_Q4.REJ, Scrap_Q4.When, Count(Scrap_Q4.REJ) AS CountOfREJ
FROM Scrap_Q4


GROUP BY Scrap_Q4.REJ, Scrap_Q4.When
HAVING (((Scrap_Q4.REJ) Between 108 And 132) AND ((Scrap_Q4.When) Between [start date] And [end date]))
ORDER BY Scrap_Q4.REJ, Count(Scrap_Q4.REJ);

I want to replace the parameter box from popping up with a calendar which will alow the user to click on a start date and an end date. This will eliminate typing and potential error.

[orange]

Create a form with some calendar controls and a button.
Use the calendar controls to get the dates.
Use the button to execute the query with the parameters.

I don't have access2007 but here's a free video
http://www.myaccessprogram.com/Videos/DatePicker.html

[dylan_dog]

Hi,

try this:

http://allenbrowne.com/ser-51.html

Regards