Your dialect of SQL is recognized by Access, but is not standard for
access. i'm not sure how you do an Outer Join this way, but the
Access standard would have your query written:
SELECT tblGroups.groupID, groupName, count(paxID)
FROM tblGroups INNER JOIN tblPax ON tblGroups.groupID =
tblPax.groupID
GROUP BY tblGroups.groupID, groupName

to make this query return NULLs, you would change it to:
SELECT tblGroups.groupID, groupName, count(paxID)
FROM tblGroups LEFT JOIN tblPax ON tblGroups.groupID = tblPax.groupID
GROUP BY tblGroups.groupID, groupName

it will return NULLs, not 0s, so you will have to process them if you
want 0s.

hope that helps, tom


"Hamish McCracken" <mrshabby (AT) hotmail (DOT) com> wrote