Access - Reports

[Guest]

I need to do a report using a query that I have set parameters in. I need to
have a Header and footer that can change to reflect the parameters, also I
need to have something in the report that allows a member of the team to put
their name in a report footer to show that they have produced the report,
like a parameter that allows them to select their name. Please help if you
understand what the hell I am talking about. Thank you

 

[Rick B]

Just add a text box to the report using the same parameter called in your
query. Note: You could search and find this same answer many times in the
newsgroup.

="Report covers data from " & [Enter Start Date] & " through " &[Enter End
Date]

or

="Report covers data from " & Format([Enter Start Date],"short date") & "
through " & Format([Enter End Date], "Short Date")



As far as the name, if they are signing in to your database using user-level
security, you can include their UserID as...

= "Report produced by: " & CurrentUser()

 

[Guest]

I have not done exactly this but it sounds similar to something i have that
works.

The parameter in the report header is just a textbox whose source is
[nameoffieldinparameterquery]. When the report runs it will stop and ask for
the value for [nameoffieldinparameterquery], user types in value, that value
appears in header when report prints.

Getting the user name may a little harder (assuming u want to prevent user A
from entering user B's name). If not then the same magic ought to work for
the name.