sparklegrrl
Registered User.
- Local time
- Today, 11:00
- Joined
- Jul 10, 2003
- Messages
- 124
I have FINALLY gotten my timecards & expenses working however, I need to make an invoice out of them and I am not sure here to do the totals.
For example.....I need an invoice that will look like this
Date Employee Reg Hrs. Reg Rate Reg Total (This should multiple hrs & rate) OT Hrs. Ot Rate OT Total (this should again multiply hrs & rate) and then TOTAL (this should total Reg Total & OT total)
I have it where it will look up the rates and print the hours & rates columns however, I am not sure how to tell it to multiply each one for the Reg Total and OT Total and then add them together.
Each job obviously may have up to 15 employees each day on it so I need it to total each one by the daily time cards.
Do I need to put a field in the timecard table that calculates each line? I think I probably so so I can run a query & a grand total of each day worked on a particular job.
If so...how do I do that in a table?
For example.....I need an invoice that will look like this
Date Employee Reg Hrs. Reg Rate Reg Total (This should multiple hrs & rate) OT Hrs. Ot Rate OT Total (this should again multiply hrs & rate) and then TOTAL (this should total Reg Total & OT total)
I have it where it will look up the rates and print the hours & rates columns however, I am not sure how to tell it to multiply each one for the Reg Total and OT Total and then add them together.
Each job obviously may have up to 15 employees each day on it so I need it to total each one by the daily time cards.
Do I need to put a field in the timecard table that calculates each line? I think I probably so so I can run a query & a grand total of each day worked on a particular job.
If so...how do I do that in a table?
