Show Dates

  • Thread starter Thread starter Fie
  • Start date Start date
F

Fie

Hi,

I have a report that when it is opened you have to enter in Start Date
and End Date... how can i get these dates to apear on the report???


fiona
 
What is the prompt you are using to get these dates from your user?

In an unbound text box on your report, enter that prompt exactly as you are
using it in your query. For example, if your criteria in the query is...

Between [Enter Start Date:] and [Enter Stop Date:]


Then you would add an unbound text box on your report with something
like....



="Report covers " & Format([Enter Start Date:],"Medium Date") & " through "
& Format([Enter Stop Date:],"medium date")



or similar.
 
Back
Top