Include Between/And in Report Title

[Guest]

I have a simple tabular report based on the following query...

SELECT DISTINCTROW [Patient Treatments Table].body_part, Sum([Patient
Treatments Table].total_number_of_consults) AS [Sum Of
total_number_of_consults], Count(*) AS [Count Of Patient Treatments Table]
FROM [Patient Treatments Table]
WHERE ((([Patient Treatments Table].first_attendance) Between [Enter Start
Date:] And [Enter End Date:]))
GROUP BY [Patient Treatments Table].body_part;

Is it possible to automatically include the parameters from the Between/And
statement into the report title?

Many thanks for your help in anticipation.

Joe

 

[Allen Browne]

Add a text box to the Report Header section.

Set its Control Source property to something like this:
="Between " & Format([Enter Start Date:], "Short Date") &
" And " & Format([Enter End Date:], "Short Date")

 

[Guest]

Thank you Allen,

Your advice was exactly the answer to my query. It works fantastically well.

Joe

Add a text box to the Report Header section.

Set its Control Source property to something like this:
="Between " & Format([Enter Start Date:], "Short Date") &
" And " & Format([Enter End Date:], "Short Date")

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I have a simple tabular report based on the following query...

SELECT DISTINCTROW [Patient Treatments Table].body_part, Sum([Patient
Treatments Table].total_number_of_consults) AS [Sum Of
total_number_of_consults], Count(*) AS [Count Of Patient Treatments Table]
FROM [Patient Treatments Table]
WHERE ((([Patient Treatments Table].first_attendance) Between [Enter Start
Date:] And [Enter End Date:]))
GROUP BY [Patient Treatments Table].body_part;

Is it possible to automatically include the parameters from the
Between/And
statement into the report title?

Many thanks for your help in anticipation.

Joe