Changing information at page footer

[John]

I have a report that three different people run. When they run the report I
would like them to put their name at the bottom of report. Right now I had to
create 12 different reports because there are four shifts and each shift is
separate. I'd like to have just 4 reports in which the entry person can enter
his name and it appears at the bottom of report.

 

[BruceM]

Depending on how you are opening the report you could require the user to
enter their name, perhaps in an unbound text box on the form from which you
open the report. Set the Control Source of an unbound text box on the
report to:

=Forms!FormName!ControlName

Use the actual form name, and replace ControlName with the name of the
control containing the user's name.

There are other ways to accomplish the same thing, depending on how exactly
the users are running the report.

 

[Al Campagna]

John,
One (of many) solutions would be to use a parameter query, to ask the
user for their name when the report runs.
Add a calculated field to your query...
UserName : [Enter your name]
When the report runs, an input box will appear, and ask for the user's
name.
On the report, place the bound control with a ControlSource of
[UserName]... where you want the name to appear.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[John]

Al,

Thanks, your solution worked Great!!!

John,
One (of many) solutions would be to use a parameter query, to ask the
user for their name when the report runs.
Add a calculated field to your query...
UserName : [Enter your name]
When the report runs, an input box will appear, and ask for the user's
name.
On the report, place the bound control with a ControlSource of
[UserName]... where you want the name to appear.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

I have a report that three different people run. When they run the report I
would like them to put their name at the bottom of report. Right now I had
to
create 12 different reports because there are four shifts and each shift
is
separate. I'd like to have just 4 reports in which the entry person can
enter
his name and it appears at the bottom of report.