Recent content by TomHefferin

Ok, I've tried creating the Outer Join as suggested (LeftOuterJoin.png) but it gives some weird results (LeftOuterJoinResults.png). So I'm guessing there is something wrong with the table linking on the Back-end. I've attached an image of the tables involved here. (CourseMats.png) Should...

Ok, thanks to both of you - that's given me something to work with. I'll get back to you after I've played around with it.

I am currently building a Training database to assign Trainees to particular Courses. One particular query is giving me issues. It includes 2 join tables tblCourseMats: Used to assign required course materials to a particular Course tblTraineeMats: Used to track which course materials a...

Hi, I'm from the UK, and have been pottering about with Access for some time, using it whenever it was a better solution than Excel. Stronger with VBA than SQL. I have often ended up here when looking to learn from others problems and solutions and thought it was about time I signed up. Hi to...