Title and Date change in report

  • Thread starter Thread starter Linda
  • Start date Start date
L

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
 
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
Click to expand...
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")
 
fredg said:
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
Click to expand...
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")
Click to expand...

Fred,

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

Linda
 
Back
Top