display user/keyboard input on an Access report

[GGoodell]

I am trying to display a date range on an Access report that is determined by
the user at the time he/she runs the report. The user inputs a start date and
an end date, the queries then run over the given date range and then are
presented in a report. I would like to display the start and ending dates the
user inputed on the report.

 

[Duane Hookom]

You can try create a text box and enter your exact parameters like:

="Report for dates between " & [Start Date] & " and " & [End Date]

 

[GGoodell]

Cool! Thanks!

I do already ask for a date range in a query that the user inputs. When I
use you idea and add this to the report it displays beautifully however the
user has to input the date range twice. Is there any way to get around this
(ie: can the report reference the date range requested by the query?).

Thanks a bunch! Your first suggestion helped a bunch.

Greg Goodell

You can try create a text box and enter your exact parameters like:

="Report for dates between " & [Start Date] & " and " & [End Date]

--
Duane Hookom
MS Access MVP

I am trying to display a date range on an Access report that is determined
by
the user at the time he/she runs the report. The user inputs a start date
and
an end date, the queries then run over the given date range and then are
presented in a report. I would like to display the start and ending dates
the
user inputed on the report.

 

[John Spencer (MVP)]

Replace [Start Date] with the exact parameter you are using in the query.
Replace [End Date] with the exact parameter you are using in the query.

Cool! Thanks!

I do already ask for a date range in a query that the user inputs. When I
use you idea and add this to the report it displays beautifully however the
user has to input the date range twice. Is there any way to get around this
(ie: can the report reference the date range requested by the query?).

Thanks a bunch! Your first suggestion helped a bunch.

Greg Goodell

You can try create a text box and enter your exact parameters like:

="Report for dates between " & [Start Date] & " and " & [End Date]

--
Duane Hookom
MS Access MVP

I am trying to display a date range on an Access report that is determined
by
the user at the time he/she runs the report. The user inputs a start date
and
an end date, the queries then run over the given date range and then are
presented in a report. I would like to display the start and ending dates
the
user inputed on the report.

 

[GGoodell]

Oofda! So easy I couldn't get to it! Works great. Thanks!

Replace [Start Date] with the exact parameter you are using in the query.
Replace [End Date] with the exact parameter you are using in the query.

Cool! Thanks!

I do already ask for a date range in a query that the user inputs. When I
use you idea and add this to the report it displays beautifully however the
user has to input the date range twice. Is there any way to get around this
(ie: can the report reference the date range requested by the query?).

Thanks a bunch! Your first suggestion helped a bunch.

Greg Goodell

You can try create a text box and enter your exact parameters like:

="Report for dates between " & [Start Date] & " and " & [End Date]

--
Duane Hookom
MS Access MVP


I am trying to display a date range on an Access report that is determined
by
the user at the time he/she runs the report. The user inputs a start date
and
an end date, the queries then run over the given date range and then are
presented in a report. I would like to display the start and ending dates
the
user inputed on the report.