Via a form I update an Access 2003 database with various information
The database & form has a field for the length of time a task took to complete. The entry is in h:mm format
Also another field for the payment amount of the completed task in $.cc format.
After the above fields have been filled, I need to populate a 3rd field with the hourly pay rate for the completed task.
The length of time a task takes & the total payment paid various with each task.
How do I calculate the hourly pay rate
The time taken is in a Textbox named tbRouteTime
The Payment amount is in a Textbox named tbValue
The Hourly pay rate goes into a Textbox named tbHourRate
Thanks in Advance for your assistance
This question has now also been posted to vbaexpress