Reports with columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report I would like to make. The data I have is a list of employees
for my division. The Division has 6 areas, and each area has 1 to 5 labor
grades. Each employee falls into a labor grade. I would like to see a page
that displays an area, then has a column for each labor grade, with the list
of employees that respectively fall into that labor grade. I am having
trouble doing this. Please help. (Having trouble centering the title, cuz it
only displays over the 1st column. Also, having trouble linking the employees
under the correct column) Should I use a sub-report? I am using Access 97. Is
this still possible?

Ex:
Sheet Mill
5 Stand
LG5 LG4 LG3 LG2
Emp1 Emp21 Emp31 Emp41
Emp2 Emp22 Emp32 Emp42
Emp3 Emp23 Emp33 Emp43
Emp4 Emp24 Emp34
Emp5 Emp35
 
Create a subreport of employees. Place this subreport in a multi-column
subreport based on Divisions and Grades. Add this subreport to a main report
based only on unique Divisions.
 
Back
Top