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

Hi K,



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?

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.

Thank you, I will try that, sorry for the delay in repsl, out on business for a few days.