Exporting non-linked and linked tables together

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dea_gek_van_budschop (Dea_gek_van_budschop_at_discussions.microsoft.com)
Date: 01/11/05 

Date: Tue, 11 Jan 2005 05:35:04 -0800

Hi,
I'm setting up a system for administrating internships for a school. Since
the system will be used by different users and they all need different output
[letters, forms, lists, sheets] in different formats from the system, I
decided not to make all the output via reports in Access. Instead, I want to
create one big export-query, that puts ALL the data from all the tables,
correctly linked in one big sheet. The users can then link this sheet with
Excel- or Word-templates or whatever they want to do with the data.

The problem.... Which I'll explain using an example:
    The four tables Student, Internship, Location and Mentor are linked
together.
    [The actual system has many more tables, but no need to make things
    complicated ofcourse ;) ]

    Table Student is linked with table Intership
    Table Location is linked with table Intership
    Table Mentor is linked with table Intership
    So the table Internship links everything together.

    Now, when there is an internship without a mentor [but it does have a
student
    and location], the whole entry isn't displayed in the query-result. But
I want
    these kind of entries shown in the result, since it is an actual
internship. Even
    though there isn't a mentor designated yet, the internship counts and
should be
    displayed, leaving the mentor-field just empty.

--- Result I want ---
    STUDENT LOCATION MENTOR
    Abra Cadabra Institute A Wan Abee
    Sjaak Trekhaak Institute B
    Rick the Slick Company C Obi-Wan Kenobi
    Pamela Anderson Institute DD Tommy Lee

--- Result I get ---
    STUDENT LOCATION MENTOR
    Abra Cadabra Institute A Wan Abee
    Rick the Slick Company C Obi-Wan Kenobi
    Pamela Anderson Institute DD Tommy Lee

Does someone know a solution for this problem?!?!

Very many thanks in advance,
Ad Steyvers

Relevant Pages

  • Exporting non-linked and linked tables together
    ... need to right join the mentor table ... >correctly linked in one big sheet. ... > So the table Internship links everything together. ...
    (microsoft.public.access.externaldata)
  • Local student gets internship
    ... That's because Kalcevic, a Rostraver Township resident and student at California University of Pennsylvania, ... recently was picked for an internship with "The Late Show With David Letterman" in New York City. ... "I sent it in to them and heard back a week later and went to New York on Nov. 1 for an interview," she said. ...
    (alt.fan.letterman)
  • RE: Exporting non-linked and linked tables together
    ... and/or stacking multiple select-statements! ... > need to right join the mentor table ... >> So the table Internship links everything together. ... >>Ad Steyvers ...
    (microsoft.public.access.externaldata)
  • IBM Help
    ... I have student who has received a very attractive internship offer because of the training I provided him in COBOL a year ago. ... We worked with Fujitsu COBOL in the PC environment - both the student version and the professional version. ... The internship site knows this is not part of his background, but he wants to be as prepared as possible as he starts his summer activities. ...
    (comp.lang.cobol)