2 Sets of Totals

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?
 
R

Ragnar Midtskogen

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
..
 
K

Kevin

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.
 
R

Ragnar Midtskogen

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top