Showing the range of dates in header?

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

I am slowly learning Access and have created a report to
show referrals that were made between a range of dates
that are entered in the Parameters message box. Is there
any way to show those dates at the top of my report? Is
there some sort of code? I have looked several places but
I can't seem to find anything to help me with this.

Thanks in advance.
 
Just include the criteria from the query in your report. For example...

Let's say that in your query under the field "DateOfSale" you have the
criteria...

Between [EnterStartDate] and [EnterEndDate]

In the report you would need to add a text box and put something like...

=[EnterStartDate] & " through " & [EnterEndDate]


Hope that is what you are looking for.

Rick
 
Back
Top