Report based on drivers name

I am trying to create a database to track loads run by my trucking company. I am hung up on generating a report for the driver's payroll. My trucks typically run with team drivers so I have fields for "Driver A" and "Driver B". I also have fields that indicate the number of miles the load is and the rate per mile each driver is to be paid.

I need a report that will pull the pay details for each individual driver whether they are listed as "A", "B", or both. (A driver may be listed as both if he runs a load as a solo). It is also important that the report does not show what their co-driver is being paid as it will be used as their pay statement.

Any help would be appreciated.