Showing Date on Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Welthey - 06 Mar 2007 17:23 GMT

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?

Reply to this Message

Jeff Boyce - 06 Mar 2007 17:30 GMT

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

>I need to show a date in the Report Header part of my report. Currently
>the
[quoted text clipped - 3 lines]
> whole
> report to figure out what the date is. Is there anyway to do this?

Reply to this Message

Welthey - 06 Mar 2007 17:46 GMT

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.

> Open the report in design view.
>
[quoted text clipped - 15 lines]
> > whole
> > report to figure out what the date is. Is there anyway to do this?

Reply to this Message

Jeff Boyce - 06 Mar 2007 20:39 GMT

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

> But what if I want the date that I am pulling. For instance, I want to
> see
[quoted text clipped - 20 lines]
>> > whole
>> > report to figure out what the date is. Is there anyway to do this?

Reply to this Message