Difficult to explain - Urgent help needed!

[RustyR]

If you are reading this, thank you!
I'll try to explain but if I am not clear and you think you can help, please
let me know and I will zip up the DB for you to see.
Ok, I have been given a database that has employees and their skillsets 2
tables: Employees and Employees_skills linked by a unique employee ID.
I have created pseudo-employees with 'baseline' skillsets for each
particular Role and level of expertise required. They also have unique
employee IDs.
The actuals Skills are broken down into 3 tables Super Catagory, Category
and finally Skills.
What I want to do is select all skills from a pseudo-employee based on it's
employee_id, and display them - no problems yet...There should be about 133
required skills.
However, when I add the 'Real' employee tables, I want to display all
Required skills (found in the pseudo-employee) and next to them display the
real employee's skills EVEN IF THERE IS NO VALUE FOR THAT SKILL. Therein
lies my dilemma. When I link the pseudo-skills to the real skills, I only
get back those skills where I match so I lose the rest of the pseudo-skills.
I can't do a left or right join without Access throwing an error. I have
beat myself up all day on this!!!
This probably does not make too much sense, but if anyone can help, I would
certainly appreciate it!

Regards,

Rusty

 

[Marshall Barton]

If you are reading this, thank you!
I'll try to explain but if I am not clear and you think you can help, please
let me know and I will zip up the DB for you to see.
Ok, I have been given a database that has employees and their skillsets 2
tables: Employees and Employees_skills linked by a unique employee ID.
I have created pseudo-employees with 'baseline' skillsets for each
particular Role and level of expertise required. They also have unique
employee IDs.
The actuals Skills are broken down into 3 tables Super Catagory, Category
and finally Skills.
What I want to do is select all skills from a pseudo-employee based on it's
employee_id, and display them - no problems yet...There should be about 133
required skills.
However, when I add the 'Real' employee tables, I want to display all
Required skills (found in the pseudo-employee) and next to them display the
real employee's skills EVEN IF THERE IS NO VALUE FOR THAT SKILL. Therein
lies my dilemma. When I link the pseudo-skills to the real skills, I only
get back those skills where I match so I lose the rest of the pseudo-skills.
I can't do a left or right join without Access throwing an error.

You do need a Left or Right Join.

You probably have an Inner Join to one or more of the other
tables and either need to make those outer joins too or
change the way the joins are nested.

If you can't figure something out based on those clues, post
a Copy/Paste of your query's SQL statement and we'll see
what we can figure out.