List records based between 2 dates and do math
I have 3 forms, LOADS, DRIVER, CREATE SETTLEMENT.
The LOADS form has following fields:
Load #
Driver Name (look-up from DRIVER)
Driver Pay
Delivery Date
DRIVER has the following fields
Driver Name
In CREATE SETTLEMENT I want to be able to 1) select a driver, 2) put a TO and FROM date, 3) list all Load #'s completed by that driver that was delivered within the TO and FROM dates, and 4) calculate the total driver pay for all loads delivered in the same time frame.
Any help would be MUCH APPRECIATED!