Display blank fields in access

I'm trying to create a query that will show me the activities from various
schools.

I have a table that lists each of the 55 schools at which my staff works. I
also have 5 separate queries that list the frequency of each of the following
activities (intakes,individuals, groups, presentations, mediations).

Not all of the activities occur at each school. So of course, if the group
query shows no groups at "Freedom School", Freedom is left out of the mix
altogether.

Is there any way to get the query to display each of the 55 schools, and if
one of the "sub-queries"(is that the correct term?) doesn't have any data for
that school, to just return a blank or zero value?

Sorry, I know that this is probably a pretty elementary question, but I've
been searching the help topics for weeks, and I just can't figure it out.

Thank you!

It will be easier to offer help if you tell us what tables you have and how
they are related. You mention only one table. Where does the list of staff
members come from?

-Dorian

"DeAnna" wrote:

I'm trying to create a query that will show me the activities from various
schools.

I have a table that lists each of the 55 schools at which my staff works. I
also have 5 separate queries that list the frequency of each of the following
activities (intakes,individuals, groups, presentations, mediations).

Not all of the activities occur at each school. So of course, if the group
query shows no groups at "Freedom School", Freedom is left out of the mix
altogether.

Is there any way to get the query to display each of the 55 schools, and if
one of the "sub-queries"(is that the correct term?) doesn't have any data for
that school, to just return a blank or zero value?

Sorry, I know that this is probably a pretty elementary question, but I've
been searching the help topics for weeks, and I just can't figure it out.

Thank you!