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

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?
 
P

PC Datasheet

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]
 

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
show criteria data from a query on a report using that query 2
parameter query linked to a form 5
Sorting report by date range 2
Using Between Dates in a Query 4

Top