Display Parameter Value on Report Header

[Taff]

Hi All,

Have a report which has two date parameters.

Is it possible to display these parameters in the report somewhere, preferably in the Header?

Thanks


Anthony

 

[WayneRyan]

Anthony,

One thing that you can do is make a dialog box to get the two
dates from the user. The dialog box can have a command
button that will launch the report.

The report can be based on a query that uses:

Between Forms![YourDialog]![StartDate] And Forms![YourDialog]![EndDate]

The form MUST be open and you can reference the form's fields
on your report.

Wayne

 

[AN60]

Assuming your dates are beginning and end dates. I use the following in an unbound text box in a report wherever I want to view/print the beginning & end dates;

="From " & [beginning date] & " To " & [ending date]

 

[Taff]

Thanks for replying guys.

Used AN60's solution and it worked great.

Much appreciated.


Ant