Title and Date change in report

[Linda]

Hi guys,

Using Access 2000. I have a report that is a sign in sheet for our
department employees. We use it for department meetings, in-services
etc....Is there a way to make the title of the report and date fields ask
for a parameter without basing it on a parameter query so anyone can just
type in the title and date without going into the report design? I don't
want the report to be saved just changed each time.

Thanks,

Linda

 

[fredg]

Hi guys,

Using Access 2000. I have a report that is a sign in sheet for our
department employees. We use it for department meetings, in-services
etc....Is there a way to make the title of the report and date fields ask
for a parameter without basing it on a parameter query so anyone can just
type in the title and date without going into the report design? I don't
want the report to be saved just changed each time.

Thanks,

Linda

Linda,
If you just want a label printed on the report, without it actually
filtering any records, add an unbound control to the Report Header.
Set it's control source to something like:
= "Report of a meeting held by " & [Enter Department] & " on " &
Format([Enter Date],"mmmm d, yyyy")

 

[Linda]

Hi guys,

Using Access 2000. I have a report that is a sign in sheet for our
department employees. We use it for department meetings, in-services
etc....Is there a way to make the title of the report and date fields ask
for a parameter without basing it on a parameter query so anyone can just
type in the title and date without going into the report design? I don't
want the report to be saved just changed each time.

Thanks,

Linda

Linda,
If you just want a label printed on the report, without it actually
filtering any records, add an unbound control to the Report Header.
Set it's control source to something like:
= "Report of a meeting held by " & [Enter Department] & " on " &
Format([Enter Date],"mmmm d, yyyy")

Fred,

Gee that was easy. I made some other reports too that could be customized.
Thanks a million!

Linda