Need help to build a report for this project:

A trucking company has many contract drivers and each driver receive a weekly driver report with the containers they hauled and with subtotal earnings. I created this report by date range and driver and gross income.

Here is the challenge: On the bottom of this report I need to deduct for the pay period expense items such as gas, insurance, damages etc. from the earnings for each pay period and each driver that is deducted from the gross pay.

I like store the expense information by driver and by pay period in a separate table but do not know how to best access and import the expense info into the report. (Matching the driver and pay period)

What is the easiest way to find and retract the expense information by driver and pay period later on?

Can I do this in a portal or a better method? If so, how would I do this?

Any help is appreciated.

-- Udor

It is usually best to combine income and expense items in the same table and tag them by using a type field. Each record would have the DriverID, Expense TypeID, etc.

Then, report from that table using Finds and subsummaries and grand totals.