reports by selected data

[bone head]

Long shot here but thought I would ask anyway

I have a report which on opening the user enters into message boxes the beginning date, and end date of records they wish to include in the report.

Is there any way to include these dates selected into the report i.e. in the header or footer, or anywhere else come to it.

Any suggestions

 

[WayneRyan]

bone head,

If you have an OPEN form, where they enter the desired dates,
then you can:

Place two controls anywhere on your report and set their
control source to: =Forms![YourForm]!Date1

hth,
Wayne

 

[bone head]

Are you saying that they would need to enter the date again once the form is open.

they enter the date as part of the queery which forces a message box for the data, they can not get the form open without this data.

am i misunderstanding you

Paul

 

[WayneRyan]

Hi Paul,

Slight misunderstanding on my part.

Generally, our reports are triggered by a command button,
they bring up a dialog box for selecting date ranges, projects,
etc. This dialog box runs the report and the controls are
available to the report with the syntax I mentioned last time.

In your case, the control source is available through your
query. You should see it in the dropdown list in the properties
for your controls.

hth,
Wayne

 

[bone head]

Cheers

Where do i find these controls, i have looked in both the form and query, I know i am missing something obvious here.

And if i find them haow do I insert them into the report

Cheers

Paul

 

[WayneRyan]

Paul,

You'll find the controls when you get into design
view for a form or report. Make a copy of your
database and experiment. Right-click on one
of your data fields and choose properties.

This will show you where the data comes from,
how it is formatted and any events that might
be triggered by changing it.

The control source for your new controls will
be:

Forms![YourForm]!Date1

Wayne