Printing date range on Report

[Guest]

I am running a report based on a query using the date selection criteria,
BETWEEN ---- AND-----. Is there any way of printing this date range in the
header of the report.

I would also like to take the totals from this query and put them into a
table using the date range as an identifier, is this possible?

 

[Douglas J. Steele]

Are the dates picked up as parameters (either prompting the user to enter
them, or referring to controls on an open form, or set in code)?

Simply put the name of the parameter as part of the ControlSource for a text
box:

="This report for data between " & [Start Date:] & " and " & [End Date:]

 

[Guest]

Hi Douglas

When the report is run the user is prompted to enter the date range
required. This date range is linked to one field, 'Date of Claim'.
Hope that makes sense?

Are the dates picked up as parameters (either prompting the user to enter
them, or referring to controls on an open form, or set in code)?

Simply put the name of the parameter as part of the ControlSource for a text
box:

="This report for data between " & [Start Date:] & " and " & [End Date:]

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I am running a report based on a query using the date selection criteria,
BETWEEN ---- AND-----. Is there any way of printing this date range in the
header of the report.

I would also like to take the totals from this query and put them into a
table using the date range as an identifier, is this possible?

 

[Guest]

="Claims for Period " & Format$([Enter Beginning Date],"mmmm d"", ""yyyy") &
" through " & Format$([Enter Ending Date],"mmmm d"", ""yyyy")

The prompts from the query and those in the above text box need to be exact.
Otherwise the user will be prompted twice.

Hi Douglas

When the report is run the user is prompted to enter the date range
required. This date range is linked to one field, 'Date of Claim'.
Hope that makes sense?

Are the dates picked up as parameters (either prompting the user to enter
them, or referring to controls on an open form, or set in code)?

Simply put the name of the parameter as part of the ControlSource for a text
box:

="This report for data between " & [Start Date:] & " and " & [End Date:]

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I am running a report based on a query using the date selection criteria,
BETWEEN ---- AND-----. Is there any way of printing this date range in the
header of the report.

I would also like to take the totals from this query and put them into a
table using the date range as an identifier, is this possible?

 

[banem2]

I am running a report based on a query using the date selection criteria,
BETWEEN ---- AND-----. Is there any way of printing this date range in the
header of the report.

I would also like to take the totals from this query and put them into a
table using the date range as an identifier, is this possible?

I am rather using form to set dates from-to and then on report I am
using "= forms!frmFilter!fldDateFrom" and "= forms!frmFilter!
fldDateTo" to retrieve those values and print them in Header. You can
set filter to query in the same way using above.

To use same query as record source to create table, just save a copy
of query and change it to Create Table Query.

Regards,
Branislav Mihaljev