Question Need some ideas on bulding a query

[Squirrel1970]

I have a database that I use to track employee skills on a wide variety of subjects. The way I have it set up is a form with checkboxes for each subject. These are stored in my tblSkillSets. I also have another table with identical fields that I use to store the capacity for each of these subjects.

So what I need to figure out now is how I can create a query that will count the # of employees in my tblSkillSets for each subject that has a "true" value for that subject and then also show the capacity for that subject from my tblSkillCapacities in the same query.

There's another phase that I need to work on also but I need to get past this portion first.

Just trying to brainstorm this process and I could use a little help.

Thanks

 

[Galaxiom]

I don't really understand your structure. Does the capacity record apply to the skill or to the level of competence of the employee?

Why do you have a separate tables for skill and capacity when they have "identical fields"?

Indeed, if the employee has a record for a capacity then does this not indicate they have the skill? The absence of a capacity record would indicate they don't have the skill. The skill table appears to be redundant.

Moreover, your current structure sounds like an employee could have a capacity recorded without having the skill checked which means data normalisation is breached.

Perhaps I have misunderstood your explanation.