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.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 12.
