Showing Date on Report

[Guest]

I need to show a date in the Report Header part of my report. Currently the
criteria to print the report asks you to choose a specific day. I want the
date to show on the report up by the title to avoid looking through the whole
report to figure out what the date is. Is there anyway to do this?

 

[Jeff Boyce]

Open the report in design view.

Add a textbox in the header.

Set the ControlSource of the textbox to "=Date()" (for today's date) or
"=Now()" (for date/time) -- don't include the quote marks.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

But what if I want the date that I am pulling. For instance, I want to see
all the information from 12/06/2006 - I would want the 12/06/2006 to print
with the title of the report.

 

[Jeff Boyce]

Two approaches:

1) use a form to "gather" the date you are "pulling" (note that this give
you a way to have the query doing the "pulling" refer to the form/field for
its value). In the report, refer to the form/field to display the value,
with something like:
=Forms!YourForm!YourControl

2) In your report, add a text control, and add "=[Enter the pull date]"
(without the quotes) in the ControlSource.

Regards

Jeff Boyce
Microsoft Office/Access MVP