date range to print on report header

[taylornow]

Hello everybody. I have a report that is generated by a query with date parameters. Is there a way to make the dates they enter for their report appear in the header of the report? I have the current date but need the date range they ask for to be visible when it is printed.



Thanks in advance
Taylor

 

[jdegeorge]

Yes. Put a TEXT BOX in the report header. Set the CONTROL SOURCE to:

="Report for the Period: " & [BeginningDate] & " - " & [EndingDate]

Where, [BeginningDate] and [EndingDate] are the range fields from your query.

This should do it for you.

HTH "Get it right the first time, that's the main thing..."

 

[taylornow]

Have I told you today you are the best ?? You are ! Thanks so much.

taylor

 

[jdegeorge]

Taylor:

Sounds like it worked for you. Thanks! Always glad to help.

Jim "Get it right the first time, that's the main thing..."