Aug 5 2011, 02:01 PM
I have a make table query with date parameters, everything is working just as I had planned, however the dept that I made this for would like to have the date range they selected added to the report footer. Honestly, I can't for the life of me figure out how to do this(if possible). any ideas would be appreciated.
Aug 5 2011, 02:05 PM
What is the source of the report's data? In other words, what's in its Record Source property? If it's the new table, how are you opening the report?
Aug 5 2011, 02:45 PM
Are you using input parameters from the query itself or controls on a form?
If from the query, you should be able to type in the text that is displayed when the date parameter is requested. For instance, if [Enter Start Date] is displayed, then in the report, you can type =[Enter Start Date] in the control's control source property. This assumes the query is still open.
If from a form, then just type in the name of the control that contains the date: =[Forms]![NameOfForm]![NameOfControl]. This assumes the form is still open.
Aug 12 2011, 08:02 AM
Thank you, I will try that, sorry for the delay in repsl, out on business for a few days.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here