Solved Show dates on report filtered in query

[rondon]

Good afternoon, I have a report which filters the data by a between [Start date] and [Last date] in a query. How do I get those two dates to appear on the report so the user knows what data range was selected when the report is printed. Thanks Ron

 

[theDBguy]

Hi Ron. You could try using the same parameters on your report, for example:

=[StartDate]

or, use a Form to ask for the dates.

 

[arnelgp]

the parameter has space on it.

add two unbound textbox on your report (txtStart, txtEnd).
on their Control Source property, type:

=[Start date]
=[Last date]

respectively.

 

[Deleted member 147267]

[Start date] and [Last date] in a query

If these are fields in the report, then you can use them as part of a report title or something that defines the range in a calculated textbox; e.g.
= "Sales From " & [Start date] & "to " & [Last date]
Since the fields are in the query, you can easily add them to the report if they're not already on it - just hide them as they're probably not necessary to the user.
EDIT
If hidden, you can also make them very small so as to not take up space. Also, I would not use separate fields to construct the info line because the values will be different widths at times, thus alignment becomes a problem. If you put the entire line of information in one textbox, it won't matter if you use numbers or words for dates:
Monday, May 2, 2020 will align and fit just as nicely as Thursday, January 25, 2020 but not if you place one date textbox beside another.

 

[rondon]

Thank you all for your thoughts they all have given me options Thanks Ron