Including Start and End dates in Report Title automatically

[Guest_imported]

Please someone stop my confusion.

I have a report which which generates a list of new business enquiries between 2 dates. It asks the user to input the start and end dates and uses these for the query.

However, I can not work out how to get these same dates to enter automatically into the title.

e.g. "New Enquiries for period begining {date1} and {date2}"

The simpler the solution the better.

Grateful in advance. I hope!!

 

[james2308]

gary,

I do this as well, and what i do is have the date request text boxes and report lanuch button on a form.

Then, in the report header i put two text boxes, each of which has =[Forms]![frmDateSelect]![Field Name] in its Data/Control Source property.

Does that make sense?

James

 

[Aivars]

me!txtHeaderText= "New Enquiries for period begining #" & date1 & "# and #" & date2 & "#"

Aivars

 

[JoeMiller]

If you are using a parameter query (the user enters the dates that popup when the report is run) you can put controls on the report that reference your parameters.

Example:
Parameter Criteria:
[Enter Start Date],[Enter End Date]
Make a control with control source:
=[Enter Start Date], =[Enter End Date]

The dates will then show up in a control on your report. You can combine this with concatenation (as in Aivars suggestion) to:

="New Enquiries for period beginning " & [Enter Start Date] & " and " & [Enter End Date] & "."

HTH Joe Miller
joe.miller@flotech.net