Querying multiple tables

[rven]

I'm sort of an Access noob. Been teaching myself things over the past few years as I have needed to.
I am trying to do query from 3 or 4 tables and I would like it to show me all of the data, not just the 4 that have info on all of the tables.

What I have is a master table with all the ID information and 3 linked tables with donations from different events. I would like a query with first name, last name, donation event 1, donation event 2, and donation event 3, even if the person only donated at one of the event.

I realize that my problem is probably with how the query is joining properties, but I can't figure out a way to get me all of the information that I am looking for.

 

[pbaldy]

Right click or double click on the join line in design view to edit the join. You'll get a pretty good description of the 3 options.

By the way, a table for each event is a normalization mistake. Typically I'd expect a single donations table, with a field for the event.

 

[rven]

I have clicked on the join line and tried different options, but I still wasn't able to get all the data from the 3 events.

I have each event as a separate table so that I can track their giving for that event over the years.

 

[pbaldy]

I have each event as a separate table so that I can track their giving for that event over the years.

Doesn't change my point; you just include a date field to separate a donation this year from last.

Without seeing what you've tried or the db, I can only speculate, but you'd want the "all records" on the master table.

 

[pervez]

If you need all the data record you must make sub query of the queries. It will solve your problem