show criteria data from a query on a report using that query

  • Thread starter WilliamTheQueryMaker
  • Start date
W

WilliamTheQueryMaker

I have a report that runs a query with a date range parameter criteria. It
works great, now I want to display the entered date range on the report. Is
this posible or do I have to get the range on a form?

In the query, I have the following criteria "Between [Enter From Date:] And
[Enter To date:]"
Now I want to display what the user entered on the report.
 
J

John Spencer

In a control on the report enter

="Between " & [Enter From Date:] & " And " & [Enter To date:]

You can refer to the parameters in the query as if they were fields (in most
cases).

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
R

RonaldoOneNil

Create the two text boxes on the report and make the control source exactly
the same as you have in your query
i.e.
=[Enter From Date:]
=[Enter To date:]
 

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