Thanks for the suggestion, but I think I need to explain
some more. I have three table, Employees (tblEmployees),
Training Sessions (tblSession), and Enrollment
(tblEnrollment). tblEmployees contains employee
information, tblSession contains information on indivudual
training session. Training sessions are not based on a
course list, but may be about anything at any time. For
instance, there could be a training session on furnace
operation, attended by five employees. tblEnrollment is a
junction table, with FKs linked to the PK for Employee and
Session. It also contains the date. Session information
is entered on a form tied to tblSession; a subform lets
the user list the names of attendees and date of
attendance; it is tied to the junction table. The report
is based on a query constructed in such a way as to list
employee, training description, training date, instructor,
etc. The reports are grouped by employee name, with each
employee's name at the top of a new page (in the group
header), followed by (in the report detail) the individual
training sessions listed chronologically.
I have noticed that the query only sums the training for
each record. I do not get a sum of the employee's total
training time, but rather the total for that record. (I
picked up on this since my last posting). So the query is
not going to work as it stands. The system you suggested
does not work, if I understand it correctly. I added a
page footer, and put the text box there. It results in
#Error in the text box. There is no suggestion in Help as
to what that means.
If I filter the report's record source (the query) by
employee, each training session the employee attended is a
separate record (each session contains information about
the length of the session). Somehow I need to sum the
training time for all records for that employee.
-----Original Message-----
I would just do the calculation on the report (instead of
in the Query) in a text box. Group the report on Employee,
then make the footer visible and put the text box there.
Make the control source of the text box " =Sum
([TrainingTime])"
-----Original Message-----
I have arranged training records into groups in a report,
with a separate page for each employee. The report is
based on a query. One of the query fields is a
calculation of the total training time for the period
specified by the query. I would like this total to appear
immediately below the last record if possible, or in a
footer if not. I can get it to appear below every record,
but not below just the last one.
.
.
