Run Query from date to date, Print the from date to date in the header of the report?

  • Thread starter Thread starter Dustin Swartz
  • Start date Start date
D

Dustin Swartz

My Query prompts me for a "from date" and a "to date"

Now how can I get that Date span to print on my report header?
 
The parameters are treated as just another field in the returned recordset,
so use
something like this in the Open event of the report:

Me.Caption = "THIS REPORT BEGINS ON "& [Enter Start Date] _
& " AND ENDS ON " & [Enter Ending Date]
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Question 1
Duplicate prompts in crosstab query and subsequent report 1
query based on date ? 1
Oldest and Most Recent dates in header 1
The query cannot be completed. 1
Sorting report by date range 2
Using Between Dates in a Query 4
show criteria data from a query on a report using that query 2

Back
Top