I have created a report that lists on duty hours for each driver along
with a column showing a sum of the previous six days. When a driver
has been off duty for over thirty-four hours, the total needs to be
reset to zero. Should I create a subquery in order to do this or is

I have a report that, through groupings, gives me a students email address
and that individuals details I am wantingto send them.
Is their a fairly simple way to get ACCESS 2007 to take this big report and
then email each individuals details to that individual?  Something along the

Any ideas on how to produce the following report that calculates the Actual, %
diff, & Decision columns?
- The Freq_By_Days is a stored value in my table (This one I got ok)
- The Actual_By_Days is a calculated field (ActualByDays: Date()-

I have a report that displays several lines (records) per customer, amounting
to 1 or 2 pages per customer (variable), with a forced new page after each
customer. I've used "force new page after section" in the Properties but have
also tried it with a page break in the group footer. ...

How can I hide the page footer on page 1 of a report?
Thanks
Tony