Displaying a date range on a report

  • Thread starter Thread starter Grace
  • Start date Start date
G

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
 
Add a text box with a control source of
="Dates between " & [Forms]![HelpDeskRptForm]![ReportStartDate] & " and " &
[Forms]![HelpDeskRptForm]![ReportEndDate]
 
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
Click to expand...


.
Click to expand...
 
Back
Top