Hi all

I have a question.

I have 2 tables

Table 1

Date Emp.name emp.nr product kg
08.05.97 Per Simmer 455 Merluzzo 345,5
08.05.97 Per Simmer 455 Trapez 145,5
08.05.97 Per Simmer 455 Block 445,5
08.05.97 Per Simmer 455 Discards 45,5


Table 2
Emp.name emp.nr Salary type hour
Per Simmer 455 Reg.hour 5,5
Per Simmer 455 Prod.hour 45,5
Per Simmer 455 Shift hour 45,5

Table 1 is ordered by date employeename
the amount off fields for each date can vary
from 3 ore more depending on witch product
the employee have been producing.

Table 2 is ordered by employeename and is
the sum off hour during the week.
The amount off fields can vary.


I want a report witch prints what the employee
has been producing each day, and in the bottom
off the report i want the result off table 2 displayed.

How to solve this??

Best regards

Per Simmersholm