Hi,
I'm trying to build a report that gives me the sum of our labor costs.
I have two tables, Table 1 has the labor rates (in 2 columns, Reg/OT) and table 2 has the hours, there are two sets of codes that must match on both tables then there is also a column in table 2 that specifies whether the hours are reg or OT
Here is the data from the two tables;
Table 1 Table 2
Hours
Labor Code 1 Labor Code 2
Labor Code 2 Labor Code 2
Regular Pay $ Reg/OT Pay Code
OT Pay $
Job # Job #
Cost Code Cost Code
This will also be filtered by a job number and cost code.
Thanks
0 comments
Please sign in to leave a comment.