Displaying Date Range in Reports

[Guest]

I have a report filtered by a query: begin date - end date. How can I
display these dates on report? Thanks.

 

[Guest]

Hi Nick

Place the field containing the date in the detail section

or

Place in the field header (if you have sorted the report by date and
selected field header) to give details of each date.

Hope this helps

 

[Joan Wild]

You can simply repeat the parameters in a textbox on the report. So if you have criteria of
Between [begin date] And [end date]
in your query, put a textbox on your report with the following as the control source:
="For the period " & [begin date] & " to " & [end date]

 

[Guest]

Thanks Wayne,
I get the date to display in the report but it requires me to type the begin
and end date parameters twice. Is the way to only have to type them in once?
Thanks for your time.

 

[Guest]

Thanks Joan,
Is there a way to display the range without having to type the parameters in
twice? Thanks again.

You can simply repeat the parameters in a textbox on the report. So if you have criteria of
Between [begin date] And [end date]
in your query, put a textbox on your report with the following as the control source:
="For the period " & [begin date] & " to " & [end date]


--
Joan Wild
Microsoft Access MVP

I have a report filtered by a query: begin date - end date. How can I
display these dates on report? Thanks.

 

[Guest]

You shouldn't need to. Assuming you have the report based on the query, any
criteria in the query will be passed to the report.


--
Wayne
Manchester, England.

Thanks Joan,
Is there a way to display the range without having to type the parameters in
twice? Thanks again.

You can simply repeat the parameters in a textbox on the report. So if you have criteria of
Between [begin date] And [end date]
in your query, put a textbox on your report with the following as the control source:
="For the period " & [begin date] & " to " & [end date]


--
Joan Wild
Microsoft Access MVP

I have a report filtered by a query: begin date - end date. How can I
display these dates on report? Thanks.

 

[fredg]

Thanks Joan,
Is there a way to display the range without having to type the parameters in
twice? Thanks again.

You can simply repeat the parameters in a textbox on the report. So if you have criteria of
Between [begin date] And [end date]
in your query, put a textbox on your report with the following as the control source:
="For the period " & [begin date] & " to " & [end date]

--
Joan Wild
Microsoft Access MVP

I have a report filtered by a query: begin date - end date. How can I
display these dates on report? Thanks.

The text within the brackets MUST be identical to the bracketed text
in the query.

 

[Guest]

Worked!! Thanks!

Thanks Joan,
Is there a way to display the range without having to type the parameters in
twice? Thanks again.

You can simply repeat the parameters in a textbox on the report. So if you have criteria of
Between [begin date] And [end date]
in your query, put a textbox on your report with the following as the control source:
="For the period " & [begin date] & " to " & [end date]


--
Joan Wild
Microsoft Access MVP

I have a report filtered by a query: begin date - end date. How can I
display these dates on report? Thanks.

 

[Guest]

Thanks Fred!

Thanks Joan,
Is there a way to display the range without having to type the parameters in
twice? Thanks again.

You can simply repeat the parameters in a textbox on the report. So if you have criteria of
Between [begin date] And [end date]
in your query, put a textbox on your report with the following as the control source:
="For the period " & [begin date] & " to " & [end date]

--
Joan Wild
Microsoft Access MVP
I have a report filtered by a query: begin date - end date. How can I
display these dates on report? Thanks.

The text within the brackets MUST be identical to the bracketed text
in the query.

 

[Guest]

Thanks Wayne!

You shouldn't need to. Assuming you have the report based on the query, any
criteria in the query will be passed to the report.


--
Wayne
Manchester, England.

Thanks Joan,
Is there a way to display the range without having to type the parameters in
twice? Thanks again.

You can simply repeat the parameters in a textbox on the report. So if you have criteria of
Between [begin date] And [end date]
in your query, put a textbox on your report with the following as the control source:
="For the period " & [begin date] & " to " & [end date]


--
Joan Wild
Microsoft Access MVP
I have a report filtered by a query: begin date - end date. How can I
display these dates on report? Thanks.

 

[Joan Wild]

You shouldn't have to type in the parameters twice. ensure that what you have between the square brackets is typed *exactly* the same in both the query and in the control source of the textbox on the report.

--
Joan Wild
Microsoft Access MVP

Thanks Joan,
Is there a way to display the range without having to type the parameters in
twice? Thanks again.

You can simply repeat the parameters in a textbox on the report. So if you have criteria of
Between [begin date] And [end date]
in your query, put a textbox on your report with the following as the control source:
="For the period " & [begin date] & " to " & [end date]


--
Joan Wild
Microsoft Access MVP

I have a report filtered by a query: begin date - end date. How can I
display these dates on report? Thanks.