Current Month Label

[CRBI]

I have a report created from a query. I have created a switchboard option for
my director to just click the option and it will print the report since he
doesn't really use Access or even care to see the inside of it. All he wants
is to be able to print the report once a month. I have set parameters so
that he can put in the date and it pull the correct data. However, I was
wondering if there was any way I could add a field to that report to where he
would also have to enter text as to the month he is printing out. Current
date won't work as the report is actually printed out after the month closes.
Basically, I just need some place on the report for it to say "October 2008
(although printed in November) but to where he wouldn't have to actually open
the report to have that in there. Is there any way this can be done?

Thanks!

 

[Beetle]

Add a text box to your report with a Control Source of;

=Format(DateAdd("m",-1,Date()),"mmmm yyyy")

This would display the previous month in the format of (for example);

November 2008

without your director having to do anything.

 

[CJ Mora]

You said "I just need some place on the report for it to say "October 2008

(although printed in November) but to where he wouldn't have to actually open
the report to have that in there"

I guess I don't understand why he cares about the date on the report if he's
not opening it...

Assuming he will open the report to see it (or print it), here's what you do:

1. Create an unbound text box and delete its label. This text box will
replace the label on your report.

2. In the field's Control Source, enter "=[Enter Report Month and Year for
Report Title]"

Whenever the report opens, the manager will be prompted to enter the report
month and year, and this becomes the report's title.


---cj mora