Counting Records in a Report

  • Thread starter Thread starter Charlene
  • Start date Start date
C

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.
 
Charlene said:
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.
Click to expand...


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.
 
-----Original Message-----
Charlene said:
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.
Click to expand...


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
Click to expand...
this afternoon.

Charlene
 
Back
Top