putting parameter query info in report header (Access 2000)

Topic

New Reply

We use a parameter query to create a regular report.

However, we would like the Between [Start date] And [End date] selected to be recorded in our report header. These exact dates may not exist in the record set.

Any suggestions as to how we can get them so the header reads Reports from [start date] to [end date].

Many thanks

Reply | Quote

Replies

You are almost there. Create a control in the header and put the following in the Source:

=”Reports from ” & [start date] & ” to ” & [end date]

HTH
Pat

Reply | Quote