Set up query that returns values for all groups, even if no record

T

tomeck

I want to set up a query that groups records by all possible responses, not
just all present in the data base. In particular, the data in the field is
recorded as blank, 1 through 30, 77, 88 and 99. I want to create a query
that returns the number of records for each value, even when it is a zero --
that is no records exist for that match that option.
 
E

Ed Ardzinski

I usually have some sort of list of reposnses, either via a query or table,
and use a left/right join to force display of the records where the count is
zero. Actually, they will come up as nulls unless you take measures to
actually display a zero (use Nz or something more complicated)
 
M

mscertified

You need a table that lists all possible response possibilities, then your
query does a left join against this table.

Dorian
 
Top