Query not pulling all of the info.

[Snickren]

I have a donations database compiled of some individuals and businesses. I built a query to pull all of the individuals that gave to an event we had last year but also want to include all businesses in our database. I tried doing this even on two separate queries (last years event only and businesses only) but need to pull some information from the events query regardless and once I add that table it automatically drops off the businesses that didn't donate last year. How do I get it to pull all businesses and event givers? I have the Donor information in one table and all other information pertaining to the event in the other table.

[JoeM]

If you are doing the default INNER JOIN between tables, it will only return records that appear in both tables.
If you want to return ALL the records in one of the table, regardless of whether or not it has a match in the other table, you need to use a LEFT JOIN.
See: http://www.techonthenet.com/access/queries/joins2.php

[Snickren]

Thank you!