Summary Total counts

[khashid via AccessMonster.com]

I am trying to create a simple summary of the table. I have a table having
different fields. I just want to have a total count of Records, count of
other fields city (such as NYC has 25 , Dallas 30 records), Gender (female 45
and male 22 records). Doesnt matter if i do it on report form or query.
Anyhelp would be appreciated.


Thanks

 

[Duane Hookom]

I would create totals queries for each of your "count of other fields". Use
these a subreports to place on your main report. If you only are displaying
totals, your main report should not have a Record Source.