Date Range on report

  • Thread starter Thread starter Rey
  • Start date Start date
R

Rey

I have a query that asks for a "begining date" and "end date" as
parameters. Is there anyway to poulate these two dates on a report
so
that the user knows the time frame (they just keyed) of the report?
I'm trying to summarize results for employees by week.
 
Rey said:
I have a query that asks for a "begining date" and "end date" as
parameters. Is there anyway to poulate these two dates on a report
so
that the user knows the time frame (they just keyed) of the report?
I'm trying to summarize results for employees by week.
Click to expand...


Just set a text box's Controls source to the exact same
prompt strings used in the query. E.g.

="Orders from " & [begining date] & " to " & [end date]
 
Rey said:
I have a query that asks for a "begining date" and "end date" as
parameters. Is there anyway to poulate these two dates on a report
so
that the user knows the time frame (they just keyed) of the report?
I'm trying to summarize results for employees by week.
Click to expand...

Just set a text box's Controls source to the exact same
prompt strings used in the query. E.g.

="Orders from " & [begining date] & " to " & [end date]
Click to expand...

Thanks!
 
Back
Top