Displaying a date range on a report

[Grace]

Hello, I have a report [HelpDeskRpt] that is based off a
query [HelpDeskQry]. Each record contained in the report
is dated in a field [CallLogged]. I have a form
[HelpDeskRptForm]that contains 2 unbound boxes that
prompts for a [ReportStartDate] and a [ReportEndDate].

The field [CalledLogged] on the query contains the
following criteria [Forms]![HelpDeskRptForm]!
[ReportStartDate] and [Forms]![HelpDeskRptForm]!
[ReportEndDate].

This all works GREAT! However, I would like to display
the [ReportStartDate] and [ReportEndDate] on the report
and don't know how to do this.

Any help is greatly appreciated.
Grace

 

[Duane Hookom]

Add a text box with a control source of
="Dates between " & [Forms]![HelpDeskRptForm]![ReportStartDate] & " and " &
[Forms]![HelpDeskRptForm]![ReportEndDate]

 

[Guest]

Thansk! That worked. Your help is appreciated.

Grace

-----Original Message-----
Add a text box with a control source of
="Dates between " & [Forms]![HelpDeskRptForm]! [ReportStartDate] & " and " &
[Forms]![HelpDeskRptForm]![ReportEndDate]
--
Duane Hookom
MS Access MVP

Hello, I have a report [HelpDeskRpt] that is based off a
query [HelpDeskQry]. Each record contained in the report
is dated in a field [CallLogged]. I have a form
[HelpDeskRptForm]that contains 2 unbound boxes that
prompts for a [ReportStartDate] and a [ReportEndDate].

The field [CalledLogged] on the query contains the
following criteria [Forms]![HelpDeskRptForm]!
[ReportStartDate] and [Forms]![HelpDeskRptForm]!
[ReportEndDate].

This all works GREAT! However, I would like to display
the [ReportStartDate] and [ReportEndDate] on the report
and don't know how to do this.

Any help is greatly appreciated.
Grace

.