Getting the Count of Record in a Group

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

How does one go about getting a count of the number of items in a group to
put in the group header or group footer. (If it is possible at all!) I
started down the path of DCOUNT, but when the criteria simply has a test to
see if a field is equal to itself, which sort of makes sense, but won't
work.

Thanks!

Don
 
in the group header or footer section, add an unbound textbox control. in
the control's ControlSource property, enter the following expression, as

=Count([FieldName])

substitute the correct name of a field in the detail section of the report.

hth
 
Thanks Tina!!

A little too much target fixation on DCOUNT!

Don


tina said:
in the group header or footer section, add an unbound textbox control. in
the control's ControlSource property, enter the following expression, as

=Count([FieldName])

substitute the correct name of a field in the detail section of the
report.

hth


Don said:
How does one go about getting a count of the number of items in a group
to
put in the group header or group footer. (If it is possible at all!) I
started down the path of DCOUNT, but when the criteria simply has a test to
see if a field is equal to itself, which sort of makes sense, but won't
work.

Thanks!

Don
Click to expand...
Click to expand...
 
you're welcome :)


Don said:
Thanks Tina!!

A little too much target fixation on DCOUNT!

Don


tina said:
in the group header or footer section, add an unbound textbox control. in
the control's ControlSource property, enter the following expression, as

=Count([FieldName])

substitute the correct name of a field in the detail section of the
report.

hth


Don said:
How does one go about getting a count of the number of items in a group
to
put in the group header or group footer. (If it is possible at all!) I
started down the path of DCOUNT, but when the criteria simply has a
Click to expand...
test
to
see if a field is equal to itself, which sort of makes sense, but won't
work.

Thanks!

Don
Click to expand...
Click to expand...
Click to expand...
 
Back
Top