Search results

  1. T

    Query where No match in 2 join tables

    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...
  2. T

    Query where No match in 2 join tables

    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.
  3. T

    Query where No match in 2 join tables

    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...
  4. T

    Introduction

    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...
Back
Top Bottom