2 Sets of Totals

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Need to do a report of employees and their departments.
So report lists all the required employees and then all the departments.
Required:
Bloggs
Smith
Jones
Department A
Department B
As number of employeesvary so does the department as all employees may be in
same department.
Access seems to handle the employees fine but the departments will not
display correctly.
Any ideas?
 
You need to provide some information about where the report's data comes
from.
What you are asking is sort of like "If A plus B equals 4 why doesn't C plus
D equal 5?

Ragnar
..
 
Data is a list of employees, each belonging to a department, with the number
of hours worked each day.
First part of report is rows of employees with hours worked each day (days
are the columns).
Then a list of departments (rows), underneath, with number of hours worked
per department.
Number of employees will vary and so will the number of departments.
Access seems to handle the employees fine but soon as insert departments, it
does not seem able to cope - report footers get chopped off etc.
 
It is still not clear how the report is designed, but it sounds to me like
you should use subreports.

Design one report to display employees, using the employees table as
recordsource.
Then design anoter report for the departments, using the departments table
as recordsource.
Finally you create a blank report and add the employee and the department
reports as subreports.

Ragnar
 
Back
Top