A little help with MS Access '97 please

[purplehayes]

I'm not very good with MS Access, but I'm sure someone here is a wiz at it. What I need to do is get Access to look in a table for a certain set of names (for example: last name of Jones) and then count each record that each individual Jones person has in a different table. I can do this except for the Jonses that don't have any records accumulated in the table.

These are the results I get:

Bruce Jones 2
Bill Jones 2
Bob Jones 4
Willy Jones 6
Ted Jones 2

These are the results I need:

Bruce Jones 2
Andy Jones 0
Bill Jones 2
Bob Jones 4
Willy Jones 6
Paul Jones 0
Ted Jones 2

How do I force Access to include accounts that have a zero total?

Thanks!

PH

 

[WhatWasIThinking]

You need to do a left join, not an inner join. If you're using the wysiwyg screen I think you have to right click on the join line, select properties, and say "include all records from table 1 and records from table 2 that match" or something like that. The default is an inner join, which only selects records from the first table that have a match in the second.

blah blah blah sorry I'm not quite awake yet. I hope that made enough sense to help.