Hey Guys and Gals,
Sorry but Im a bit overwhelmed with the database thing. Im great with excel spreadsheets and have got this information in a spreadsheet but I though a database would be a much better way of storing and retrieving the information.
I have just began managing a jockey (rides horses).
I want a database to record the following...
Date
Racetrack
Horse
Trainer
Result (finishing position)
Total Prizemoney Earned (user input)
Fee (every ride she earns a flat fee, i want this to go in automatically)
Jockey Share of Prizemoney (5% of Total Prizemoney earned)
Total Earned (fee plus jockey share of prizemoney).
This is the information that I want to be able to work with and from these monetary amounts, I want to be able to calculate my percentage of the Total earned.
Is anyone able to help in terms of how to set this sort of information up?
Forgive my rudeness however I have never used access, but the spreadsheet is a bit limited for the retrieval of this info.
Thanks in advance I really appreciate your help!
Cheers
Matt