Christopherusly
Village Idiot.
- Local time
- Today, 10:11
- Joined
- Jan 16, 2005
- Messages
- 81
New report record created
Report is produced
Output from database for client
Each member of staff logs how many hours they have spent working on the project
What i want to be able to do is run a query which calculates the time / charges for that report.
So when i select Mr Smith as a project leader, (in my main report table) it goes to look in the charge out rate table to see how much an hour of Mr Smiths time costs, this value is then written in the field Charge out rate for this record
I would then run another query to return hours * rate = cost
Unlike the cost i need to be able to store the charge out rate used as these change every few months.
Can anyone offer assistance / a pointer in the right direction ?
Many thanks, in anticipation.
Christophé
Report is produced
Output from database for client
Each member of staff logs how many hours they have spent working on the project
What i want to be able to do is run a query which calculates the time / charges for that report.
So when i select Mr Smith as a project leader, (in my main report table) it goes to look in the charge out rate table to see how much an hour of Mr Smiths time costs, this value is then written in the field Charge out rate for this record
I would then run another query to return hours * rate = cost
Unlike the cost i need to be able to store the charge out rate used as these change every few months.
Can anyone offer assistance / a pointer in the right direction ?
Many thanks, in anticipation.
Christophé