Prompt User

[Ty]

I need to prompt the user asking them what date range they want for their
report.

I remember this has something to do with queries - whcih I have done, but
can't remember how to get the query and the report together.

All I want to do is ask the user to provide their date range for the report.

Thanks.

Ty

 

[Rick B]

In the query (upon which your report is based) put something like the
following iin your criteria for the date field...

Between [Enter Start Date] and [Enter Stop Date]


You can then use [Enter Start Date] and [Enter Stop Date] as fields in your
report. For example, you could add an unbound text box to your report and
put the following...


= "Data between " & [Enter Start Date] & " and " [Enter Stop Date]


Rick B

 

[Ty]

I have done the query, but don't understand how to get the query associated
with the report.

In the query (upon which your report is based) put something like the
following iin your criteria for the date field...

Between [Enter Start Date] and [Enter Stop Date]


You can then use [Enter Start Date] and [Enter Stop Date] as fields in your
report. For example, you could add an unbound text box to your report and
put the following...


= "Data between " & [Enter Start Date] & " and " [Enter Stop Date]


Rick B

I need to prompt the user asking them what date range they want for their
report.

I remember this has something to do with queries - whcih I have done, but
can't remember how to get the query and the report together.

All I want to do is ask the user to provide their date range for the report.

Thanks.

Ty

 

[Rick B]

In the report's property box, you would set the "Record Source" on the
"Data" tab to the query.

Rick B

I have done the query, but don't understand how to get the query associated
with the report.

In the query (upon which your report is based) put something like the
following iin your criteria for the date field...

Between [Enter Start Date] and [Enter Stop Date]


You can then use [Enter Start Date] and [Enter Stop Date] as fields in your
report. For example, you could add an unbound text box to your report and
put the following...


= "Data between " & [Enter Start Date] & " and " [Enter Stop Date]


Rick B

I need to prompt the user asking them what date range they want for their
report.

I remember this has something to do with queries - whcih I have done, but
can't remember how to get the query and the report together.

All I want to do is ask the user to provide their date range for the report.

Thanks.

Ty