Report Date

  • Thread starter Thread starter Jeane
  • Start date Start date
J

Jeane

I have set up a report where the data comes from a
parameter query. The query asks the user to enter a
beginning date and an ending date. Is there some way to
capture that user's input and convert it to a string so it
can put on the report in a text box?

on query: Between [enter beginning date] and [enter ending
date]

on report: for the time period (beginning date) - (ending
date)

Thank you.
 
Jeane said:
I have set up a report where the data comes from a
parameter query. The query asks the user to enter a
beginning date and an ending date. Is there some way to
capture that user's input and convert it to a string so it
can put on the report in a text box?

on query: Between [enter beginning date] and [enter ending
date]

on report: for the time period (beginning date) - (ending
date)
Click to expand...


Just use the propmpt strings as if they were a field in the
query. E.g.

="From " & [enter beginning date] & " To " & [enter ending
date]
 
Back
Top