amyofficepro
New member
- Local time
- Today, 10:51
- Joined
- Jun 13, 2012
- Messages
- 3
I have re-created a disfunctional 2003 MS Access Database using 2010.. and imported the data, etc...
I've attached my Relationships Report and Query attempting to get the output I need... The required Traning Courses are entered by Company Position - The Training Courses are linked to Classes. The links with the old database to Classes were not working... I created a Table Courses Required By Position to select Multiple Values for each Position. We brought over tbl_Training_History to import Classes attended data from old database.
I simply need to report Employee Trainings Required and Classes Taken, to SHOW ALL RECORDS as need to see required Training Courses without a Class.
To do this I understand I need to Create an Outer Join Query - and did between Traning Courses and Classes. It worked with just that data, but when added Employee Table/info it gives me error message.. I'm locked up now so cannot PrtScr or CopyPaste.
This just shouldn't be this difficult! I'm hoping someone can help.
I have to leave office and will not be home for a few hours.. will check for helpful responses then.
THANK YOU!!!
Report needed to show:
All Emp
I've attached my Relationships Report and Query attempting to get the output I need... The required Traning Courses are entered by Company Position - The Training Courses are linked to Classes. The links with the old database to Classes were not working... I created a Table Courses Required By Position to select Multiple Values for each Position. We brought over tbl_Training_History to import Classes attended data from old database.
I simply need to report Employee Trainings Required and Classes Taken, to SHOW ALL RECORDS as need to see required Training Courses without a Class.
To do this I understand I need to Create an Outer Join Query - and did between Traning Courses and Classes. It worked with just that data, but when added Employee Table/info it gives me error message.. I'm locked up now so cannot PrtScr or CopyPaste.
This just shouldn't be this difficult! I'm hoping someone can help.
I have to leave office and will not be home for a few hours.. will check for helpful responses then.
THANK YOU!!!
Report needed to show:
All Emp
