Hello, I need to build a database for employee pay for truck drivers that are paid a percentage of so much per a mile, per a ton of weight that they haul ex: .13 cent a ton/mile.... 104 miles times .13 equals 13.52 a ton, the load has average 27 tons so 13.52 times 27 equals 365.04 now the driver gets 30% so 365.04 times 30% equals 109.51. Now the best part the miles and rate is ALWAYS changing, I currently do my figures in excel but I am looking for a way to create pie charts for the company's gain/loss, keeping up with income, and parts,insurance, and a lot of etc...... will access be able to help me if I learn it???

---

Reply from Alex Hedley:

Access can do most things.
You can translate your Formulas from Excel into Calculated Query Fields as shown in E8.