Exporting non-linked and linked tables together

[Guest]

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

 

[Guest]

check your joins. If you are using inter joins you may
need to right join the mentor table
look up joins in helps

 

[Guest]

Fantastic!!!
I didn't know there was a difference between using joins, or just selecting
and/or stacking multiple select-statements!

Very many thanks
Ad Steyvers

check your joins. If you are using inter joins you may
need to right join the mentor table
look up joins in helps

-----Original Message-----

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

.