Morning all,
I am having problems trying to create a query/report from the tables i have set up (which may not be set up the best way).
The objective:
I am trying to write a report that represents the total weekly number of 'points' usage of a vibration tool by 'operative'.
An 'operative' can use upto 5 items of Vibration tool per week but also may not use any at all that week.
The Problem:
The problem i have is that the 'points' are in the 'tblOperatingTools' and all the other data is in the 'tblMain'. Also the 'points' are p/hour so the report needs to multiply the number of hours usage by the number of points per tool.
The Outcome:
I would like a report looking something like this:
Date Name Item Hours Points Total Points
01/01/01 J.Bloggs
Vibration Tool #1 4 36
Vibration Tool #2 2 25
Vibration Tool #3 2 25
96
I hope this makes sense to somebody out there.
If anybody knows of the best way i should go about this i would be very grateful.
The major issue that i have is the calculations of the 'point' and there relationship between the tables. Due to my lack of knowledge and understanding this may not even be possible.
Regards in advance
Nathan
I am having problems trying to create a query/report from the tables i have set up (which may not be set up the best way).
The objective:
I am trying to write a report that represents the total weekly number of 'points' usage of a vibration tool by 'operative'.
An 'operative' can use upto 5 items of Vibration tool per week but also may not use any at all that week.
The Problem:
The problem i have is that the 'points' are in the 'tblOperatingTools' and all the other data is in the 'tblMain'. Also the 'points' are p/hour so the report needs to multiply the number of hours usage by the number of points per tool.
The Outcome:
I would like a report looking something like this:
Date Name Item Hours Points Total Points
01/01/01 J.Bloggs
Vibration Tool #1 4 36
Vibration Tool #2 2 25
Vibration Tool #3 2 25
96
I hope this makes sense to somebody out there.
If anybody knows of the best way i should go about this i would be very grateful.
The major issue that i have is the calculations of the 'point' and there relationship between the tables. Due to my lack of knowledge and understanding this may not even be possible.
Regards in advance
Nathan
