Print Begin and End dates in Report Footer?

  • Thread starter Thread starter Judy Freed
  • Start date Start date
J

Judy Freed

I am using Access to maintain a database of hours worked on certain
projects. One of the reports allows the user to input an employee number, a
beginning date and an ending date (on an Access form) and generate a report
of hours worked for that specific time period by that individual. The report
is sorted by date and there is a date header and footer.

Problem: Some people might print the report for the period 7/1/03-7/17/03.
Others might print it for 7/1/2003-7/31/2003, etc. I would like the report
footer to reflect the beginning date and ending date that the user has
specified in the Access form. I tried a text box with
=[Forms]![TrainIDForm]![BeginDate]

in the report footer but it returns a ?Name error. Any suggestions would be
appreciated. Thanks

Judy Freed
Systems Development
UNC Charlotte
(e-mail address removed)
 
Judy said:
I am using Access to maintain a database of hours worked on certain
projects. One of the reports allows the user to input an employee number, a
beginning date and an ending date (on an Access form) and generate a report
of hours worked for that specific time period by that individual. The report
is sorted by date and there is a date header and footer.

Problem: Some people might print the report for the period 7/1/03-7/17/03.
Others might print it for 7/1/2003-7/31/2003, etc. I would like the report
footer to reflect the beginning date and ending date that the user has
specified in the Access form. I tried a text box with
=[Forms]![TrainIDForm]![BeginDate]

in the report footer but it returns a ?Name error.
Click to expand...

That kind of thing should work, unless you have a spelling
error or the form was closed.
 
All mine work using just [BeginDate], you should be able
to put a test box and make it the control...
 
Actually, what I ended up using was

=Min([Date])
=Max([Date])

Thanks to all who responded!!!!!! I continually learn from this newsgroup.

Roger Taylor said:
All mine work using just [BeginDate], you should be able
to put a test box and make it the control...
-----Original Message-----
I am using Access to maintain a database of hours worked on certain
projects. One of the reports allows the user to input an employee number, a
beginning date and an ending date (on an Access form) and generate a report
of hours worked for that specific time period by that individual. The report
is sorted by date and there is a date header and footer.

Problem: Some people might print the report for the period 7/1/03-7/17/03.
Others might print it for 7/1/2003-7/31/2003, etc. I would like the report
footer to reflect the beginning date and ending date that the user has
specified in the Access form. I tried a text box with
=[Forms]![TrainIDForm]![BeginDate]

in the report footer but it returns a ?Name error. Any suggestions would be
appreciated. Thanks

Judy Freed
Systems Development
UNC Charlotte
(e-mail address removed)





.
Click to expand...
Click to expand...
 
Back
Top