If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
2 Sets of Totals
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? |
#2
|
|||
|
|||
2 Sets of Totals
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 .. |
#3
|
|||
|
|||
2 Sets of Totals
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. "Ragnar Midtskogen" wrote in message ... 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 . |
#4
|
|||
|
|||
2 Sets of Totals
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 |
Thread Tools | |
Display Modes | |
|
|