how can ms access ask me for a date range when i run a report

[stokak]

I want access to display some prompt when the report begins asking for the
date range, then have that date range be formated to read on the report
heading someting like 'Report Range: 1/1/2007 Thruough 1/31/2007"
thanks

 

[Jeff Boyce]

Create a form. Add "Start Date" and "End Date" controls.

Modify your query(ies) and report(s) to point to the form's controls for the
values.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Suzy]

Look up parameter queries in Access help. I've used these successfully for a
long time.

 

[knowshowrosegrows]

Hate to be a dolt..

But I don't know how to create a form that is not connected already to a
table or query; create enter start date and enter end date controls and then
have my query or report "point to" such a form.

 

[Rick Brandt]

Hate to be a dolt..

But I don't know how to create a form that is not connected already
to a table or query; create enter start date and enter end date
controls and then have my query or report "point to" such a form.

On the forms tab of the db window press the "New" button. In the dialog
that comes up choose "Design View" and leave the table/query option empty.
You now have an unbound form.

Drag a couple of TextBoxes onto it from the Toolbox bar and name one
"StartDate" and the other "EndDate"

Save the form and give it whatever name you like. Your queries can now
refer to those controls whenever the form is opened with syntax like...

Forms!NameOfForm!StartDate

Forms!NameOfForm!EndDate