0

Multiplying filtered values from 2 tables

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.