If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
show criteria data from a query on a report using that query
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. |
#2
|
|||
|
|||
show criteria data from a query on a report using that query
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 WilliamTheQueryMaker wrote: 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. |
#3
|
|||
|
|||
show criteria data from a query on a report using that query
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:] "WilliamTheQueryMaker" wrote: 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. |
Thread Tools | |
Display Modes | |
|
|