Access queries Related tables but different structures

  • Thread starter Thread starter mehstg1319
  • Start date Start date
M

mehstg1319

Hi everybody

I am trying to build a query to use in a report.

The report will be a monthly report for the users on the database and
will contain the data from the tables USER, PROJECTS, MARKETING and
EVENTS.

The problem I have is that if use the INNER JOIN function, it only
displays users that have an entry in all of the tables. I am also not
able to use UNION queries as the structures are different. Any ideas
on what I can use, basically all I want to do is to select everything
from the projects, marketing and events tables depending on the UserID
chosen.

Sorry if the message is confusing, I am a total Access noob


Paul
 
First a union query to select only UserID but do not use the ALL in it.
Then left join that query to the other tables on UserID.
 
Back
Top