General information
Category:
Coding, syntax & commands
Title:
2 tables in one Report
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only