Getting the Count of Record in a Group

[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

 

[tina]

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]

Thanks Tina!!

A little too much target fixation on DCOUNT!

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

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

 

[tina]

you're welcome

Thanks Tina!!

A little too much target fixation on DCOUNT!

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

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