Access queries Related tables but different structures

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
 
K

KARL DEWEY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Dsum and Dmax with structured references 1
To Query or not to Query?? 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
MS Access 2010 pivot table as subreport 0
Table Security in Access 2013 1
SUM in a UNION query 2
Access 2016 Queries 0

Top