Counting in Report with Multiple Criteria

[eevenstad]

I have a query about the Special Equipment Devices. It contains
Serial#, several columns of detail, Date, Pole#, SubName, Phase, and Feeder.
There are 15 Subs and there are as many as 4 Feeders for each Sub. I would
like to count the number of Serial#'s assigned to each Sub and Feeder to make
a summary report for this. I would like it to look like:

Feeder Phase # of Devices Date
Sub 01
01 A 12 11/2/05
01 B 10 11/2/05
02 A 8 11/8/05
etc....................
Sub 02
01 A 4 12/6/02
01 B 15 10/3/02
02 A 6 11/1/02
etc....................
Sub 03
01 A 12 11/2/05
01 B 10 11/2/05
02 A 8 11/8/05
etc....................
Sub 04
01 A 4 12/6/02
01 B 15 10/3/02
02 A 6 11/1/02
etc....................

I need to know if there is a simple way I can set up the report to show it
like this and how to write the expressions. I was thinking that I should be
able to get the generic set up of one line and the report would auto fill
down to fit as many subs and feeders as the database has and use something
like DCount("[Serial#]", "QueryName", "[SubName] = [GroupName] and [Feeder] =
[DetailTextBox] and [Phase] = [Detail2TextBox]") This is where I get stuck.
I don't know if something like this could work and I could set it up to
utilize this generic format or if I will have to create a report with all
labels and have individual text boxes to go out and count from the query.
Even then, I don't know if I know how to make it count from the query. I
seem to get errors when I do that. I am a first time poster so I apologize
if I have made this unclear.

Thanks!