Query input to show on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is based on a query which looks for a date range of
records. In the criteria line I'm using BETWEEN [start date] and [end date]

The query and report work fine. My question is, how can I have the start
date and the end date display on my report?

Thanks.
 
Set the ControlSource for an unbound text box to something like

="Data extracted for dates between " & [start date] & " and " & [end date]

(including the = sign)
 
You must log in or register to reply here.

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

Similar Threads

Summary Report 3
print a date range from parameter query on a report header? 2
Including query dates in report 1
Parameter Query In Report Title 3
Date Range in Reports 2
Form for inputing criteria for a report's query 1
Printing Query Promt Parameters in a report 2
Using Form for Criteria for Report 3

Back
Top