For troubleshooting purposes, make a new query based on the existing
QRY_ADMISSIONS, and bind the report to the new query. Use the Count()
agregate function in the new query to get a count of pertinent demographics
(SELECT DemographicFieldName, Count(ValueFieldName) As CountOfValueFieldName
FROM YourTableName WHERE ValueFieldName > 0 GROUP BY DemographicFieldName;)

This will give you a count for each unique demographic.

Of course, if you need more fields you can add them into the Query Design
grid.

HTH

The original data is not normalized.  It is best to normalize it as you
import it to facilitate querying the data.  Having a field for black and a
separate field for white and presumably separate fields for Hispanic, etc.
makes calculating statistics harder than it needs to be.  Each choice should
be mutually exclusive or if you really want to allow multiple choices, you
need to use a separate table in which to store them.

To work with the data as you have it requires an IIf() within a Sum() for
each field:

Select Sum(IIf(Black > 0, 1, 0)) As BlackSum, Sum(IIf(White >0 ,1,0)) As
WhiteSum, Sum(IIf(Hispanic > 0, 1,0)) As HispanicSum, Sum(IIf(Sex= "Male",
1, 0)) As SumMale, Sum(IIf(Sex= "Female", 1, 0)) As SumFemale etc.

You'll need separate queries if you want to produce counts of White Females
or Hispanic Males for example:
Select "White Female" As Category, Count(*)
From YourTable
Where White > 0 AND Sex = "Female"
Group by "White Female", Category;

Select "Black Female" As Category, Count(*)
From YourTable
Where Black > 0 AND Sex = "Female"
Group by "Black Female", Category;

Select "Hispanic Female" As Category, Count(*)
From YourTable
Where Hispanic > 0 AND Sex = "Female"
Group by "Hispanic Female", Category;
etc. for additional race groupings
And double the whole set for males.  Plus these queries will not account for
columns with null values.

However, you need only a TOTAL of  THREE totals queries for all combinations
regardless of how many race/sex combinations you have if you properly
normalize the data:
Select Race, Count(*) as RaceCount
From YourTable
Group By Race;

Select Sex, Count(*) As SexCount
From YourTable
Group by Sex;

Select Race, Sex, Count(*) As RaceSexCount
From YourTable
Group by Race, Sex;

You should not be using a separate field for each but a separate for each
category like --
Race - use either text label or number with a table in a one-to-many
relationship
Sex - "M" or "F"
Age - number

I'd base the report on a Query containing some calculated fields: e.g.

IsBlack: IIF([Black] > 0, 1, 0)

You could then Sum these calculated fields (on the report Footer, or a
section footer, or even in a Totals query) to get the count of people
in each group.

                 John W. Vinson[MVP]