Totaling a counted feild in a footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning,
I am trying to build a footer in a report that will total the count of each
different critiera. The report is a blind study to determin the ethnic
makeup in our Allied Health programs.

The count funtion was easy,now I want to subcount each different group and
show that data in a detail footer.

Though, I am very versed in tables and queries but new to reports and forms.
Thanks
 
Jacqueline said:
I am trying to build a footer in a report that will total the count of each
different critiera. The report is a blind study to determin the ethnic
makeup in our Allied Health programs.

The count funtion was easy,now I want to subcount each different group and
show that data in a detail footer.

Though, I am very versed in tables and queries but new to reports and forms.
Click to expand...


The quick and dirty way is to use text boxes with expresions
like:
=Sum(IIf(ethinic= "abc", 1, 0))
But that is not a good solution.

You would be better off creating a simple Totals query that
calculates the desired counts:

Select ethnic, Count(*) As EthnicCount
From thetable
Group By ethnic

and then using that as the record source in a simple report
that is displayed as a subreport in your existing report.
 
You are right the query way works best... thanks
Sometimes I just get tunnel vision when looking at a problem.
 
Back
Top