johnsqftwr
Registered User.
- Local time
- Today, 04:12
- Joined
- Jul 19, 2004
- Messages
- 29
Hi,
I need a report that produces what skills are available to a department each week.
As can be seen from the attached file for W/C 5/09 there are 3 people all with the skills, Counter Bal, Problem Pal & Reach Truck.
The Field Min_No denotes the number of staff required for that skill and the field Rank prioritizes that task. So priority 1, Problem Pal would require 1 employee and priority 2, Reach Truck 3 employees.
The report should therfore be reading:
Problem Pal 1
Reach Truck 2
Counter Bal 0
There is also a field Count Skil
=IIf(Count([Skill_name])>=[Min_No],([Min_No]),(Count([Skill_name]))) but obviously this does not go far enough to produce the true result.
Any Help Greatly Appreciated
John
I need a report that produces what skills are available to a department each week.
As can be seen from the attached file for W/C 5/09 there are 3 people all with the skills, Counter Bal, Problem Pal & Reach Truck.
The Field Min_No denotes the number of staff required for that skill and the field Rank prioritizes that task. So priority 1, Problem Pal would require 1 employee and priority 2, Reach Truck 3 employees.
The report should therfore be reading:
Problem Pal 1
Reach Truck 2
Counter Bal 0
There is also a field Count Skil
=IIf(Count([Skill_name])>=[Min_No],([Min_No]),(Count([Skill_name]))) but obviously this does not go far enough to produce the true result.
Any Help Greatly Appreciated
John
