Counting Records in a Report

[Charlene]

I have groups established with four separate time fields
in each group header. The group time fields calculate the
times from hidden detail records. I need to get a count
for each group header field that meets a particular
criteria without counting the detail fields. (example:
Dispatch Group Header time field may have the following
times 00:47, 00:31, 1:02. I need to count each dispatch
time that is under 1:00) Any help is appreciated.

 

[Marshall Barton]

I have groups established with four separate time fields
in each group header. The group time fields calculate the
times from hidden detail records. I need to get a count
for each group header field that meets a particular
criteria without counting the detail fields. (example:
Dispatch Group Header time field may have the following
times 00:47, 00:31, 1:02. I need to count each dispatch
time that is under 1:00) Any help is appreciated.

To count the number of group headers, you can insert a text
box in the group header section and set its RunningSum
property to Over All.

If you want to count all the groups, set the text box's
control source expression to =1.

If you want to count them conditionally, set its ecpression
to something like:
=IIf(somefield < 1, 1, 0)

A text box in the report footer section can then display the
total count by refering to the running sum text box.

 

[Guest]

-----Original Message-----

I have groups established with four separate time fields
in each group header. The group time fields calculate the
times from hidden detail records. I need to get a count
for each group header field that meets a particular
criteria without counting the detail fields. (example:
Dispatch Group Header time field may have the following
times 00:47, 00:31, 1:02. I need to count each dispatch
time that is under 1:00) Any help is appreciated.

To count the number of group headers, you can insert a text
box in the group header section and set its RunningSum
property to Over All.

If you want to count all the groups, set the text box's
control source expression to =1.

If you want to count them conditionally, set its ecpression
to something like:
=IIf(somefield < 1, 1, 0)

A text box in the report footer section can then display the
total count by refering to the running sum text box.
--
Marsh
MVP [MS Access]
.
Thanks Marsh. Wish me luck - I will try your suggestion

this afternoon.

Charlene