Date Range on report

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.
 
M

Marshall Barton

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.


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]
 
R

Rey

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.

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]

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top