Printing Variable Query Criteria in Report

  • Thread starter Thread starter SA
  • Start date Start date
S

SA

Simply add a control to your report header with a control source like this:

= "Between " & [Enter Start Date:] & " And " & [Enter end Date:]
 
I have a report that is based on a Query with a date range in the criteria
of one field. How can I get the date range of the query to print in the
header of the report?

The Query condition is
Between [Enter Start Date:] And [Enter end Date:]
with the result of say... 1/1/04.... 3/31/04

I would like my report to state: Failure Report for period between 1/1/04
and 3/31/04.

Thanks
Mack Neff
 
Since the user could omit the year when answering the prompts, or enter the
date in any fomrat they please, you may want to use...

= "Between " & format([Enter Start Date:],"short date") & " And " &
format([Enter end Date:],"short date")



Rick B


Simply add a control to your report header with a control source like this:

= "Between " & [Enter Start Date:] & " And " & [Enter end Date:]
 
This will require entry of the date range twice - once for the query that
drives the report and once for the report header? Am I correct?

Mack



SA said:
Simply add a control to your report header with a control source like this:

= "Between " & [Enter Start Date:] & " And " & [Enter end Date:]
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


Mack said:
I have a report that is based on a Query with a date range in the criteria
of one field. How can I get the date range of the query to print in the
header of the report?

The Query condition is
Between [Enter Start Date:] And [Enter end Date:]
with the result of say... 1/1/04.... 3/31/04

I would like my report to state: Failure Report for period between 1/1/04
and 3/31/04.

Thanks
Mack Neff
Click to expand...
Click to expand...
 
No, that's not correct. As long as you type what's inside the square
brackets identically, you should only be prompted once.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Mack Neff said:
This will require entry of the date range twice - once for the query that
drives the report and once for the report header? Am I correct?

Mack



SA said:
Simply add a control to your report header with a control source like this:

= "Between " & [Enter Start Date:] & " And " & [Enter end Date:]
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


Mack said:
I have a report that is based on a Query with a date range in the criteria
of one field. How can I get the date range of the query to print in the
header of the report?

The Query condition is
Between [Enter Start Date:] And [Enter end Date:]
with the result of say... 1/1/04.... 3/31/04

I would like my report to state: Failure Report for period between 1/1/04
and 3/31/04.

Thanks
Mack Neff
Click to expand...
Click to expand...
Click to expand...
 
Thanks so much. That did it.
Mack


Douglas J. Steele said:
No, that's not correct. As long as you type what's inside the square
brackets identically, you should only be prompted once.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


Mack Neff said:
This will require entry of the date range twice - once for the query that
drives the report and once for the report header? Am I correct?

Mack



SA said:
Simply add a control to your report header with a control source like this:

= "Between " & [Enter Start Date:] & " And " & [Enter end Date:]
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg


I have a report that is based on a Query with a date range in the criteria
of one field. How can I get the date range of the query to print in the
header of the report?

The Query condition is
Between [Enter Start Date:] And [Enter end Date:]
with the result of say... 1/1/04.... 3/31/04

I would like my report to state: Failure Report for period between 1/1/04
and 3/31/04.

Thanks
Mack Neff
Click to expand...
Click to expand...
Click to expand...
 
Back
Top