Counting group records

[BJ]

Can anyone tell me how to include a count of group records in a group
footer. I know (I think I know!) that I have to include an unbound text box
in the footer, but what expressions do I use to count the entries within a
group (subtotals I suppose).

eg: the column (group) headings are something like this:

Area Surname
London Smith
Giles
Davis
Harris

Total : = total number of surname entries

Manchester Jones
Jarvis
Coffey

Total : = total number of surname entries

What do I do to automatically count the "total number of entries" ?

Advice very welcome - Access isn't easy is it ?

K

[MGFoster]

TextBox ControlSource: =Count(*)
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

BJ wrote:

Can anyone tell me how to include a count of group records in a group
footer. I know (I think I know!) that I have to include an unbound text box
in the footer, but what expressions do I use to count the entries within a
group (subtotals I suppose).

eg: the column (group) headings are something like this:

Area Surname
London Smith
Giles
Davis
Harris

Total : = total number of surname entries

Manchester Jones
Jarvis
Coffey

Total : = total number of surname entries
What do I do to automatically count the "total number of entries" ?
Advice very welcome - Access isn't easy is it ?

[BJ]

Many Thanks for your reply and help.
In this instance, if I want to count the number of entries under "surname",
I presume that the "Control Source" is "Surname" . I had inerted : =Count
but the only this that appeared was the first entry (eg Smith) rather than a
number. What function does the (*) serve?

Thanks
K
"MGFoster" <[e-mail]> wrote in message
news:oR*****************@newsread3.news.pas.earthl ink.net...

TextBox ControlSource: =Count(*)
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

BJ wrote:

Can anyone tell me how to include a count of group records in a group
footer. I know (I think I know!) that I have to include an unbound text box in the footer, but what expressions do I use to count the entries within a group (subtotals I suppose).

eg: the column (group) headings are something like this:

Area Surname
London Smith
Giles
Davis
Harris

Total : = total number of surname entries

Manchester Jones
Jarvis
Coffey

Total : = total number of surname entries
What do I do to automatically count the "total number of entries" ?
Advice very welcome - Access isn't easy is it ?

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sorry, for the abrupt response. What I meant was: Place an unbound
TextBox in the Group Footer. Set its ControlSource to =Count(*). This
will count all rows in the Details section. IOW, you're grouping by the
Area w/ Surnames in the Detail section. After the break between groups
(the group footer) a Count(*) will count all rows (Surnames) produced
for that grouping.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlehiYechKqOuFEgEQLGcQCg5JxShuzdJDSKsBPt8vOeiC 4A/WUAoNTq
tty9EC1oR0iO+xWvpQEGpU7D
=G/th
-----END PGP SIGNATURE-----

BJ wrote:

Many Thanks for your reply and help.
In this instance, if I want to count the number of entries under "surname",
I presume that the "Control Source" is "Surname" . I had inerted : =Count
but the only this that appeared was the first entry (eg Smith) rather than a
number. What function does the (*) serve?

Thanks
K
"MGFoster" <[e-mail]> wrote in message
news:oR*****************@newsread3.news.pas.earthl ink.net...

TextBox ControlSource: =Count(*)
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

BJ wrote:

Can anyone tell me how to include a count of group records in a group
footer. I know (I think I know!) that I have to include an unbound text
box
in the footer, but what expressions do I use to count the entries within
a
group (subtotals I suppose).

eg: the column (group) headings are something like this:

Area Surname
London Smith
Giles
Davis
Harris

Total : = total number of surname entries

Manchester Jones
Jarvis
Coffey

Total : = total number of surname entries
What do I do to automatically count the "total number of entries" ?
Advice very welcome - Access isn't easy is it ?

[BJ]

Many thanks again !

That did the trick

K
"MGFoster" <[e-mail]> wrote in message
news:8k*****************@newsread1.news.pas.earthl ink.net...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sorry, for the abrupt response. What I meant was: Place an unbound
TextBox in the Group Footer. Set its ControlSource to =Count(*). This
will count all rows in the Details section. IOW, you're grouping by the
Area w/ Surnames in the Detail section. After the break between groups
(the group footer) a Count(*) will count all rows (Surnames) produced
for that grouping.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlehiYechKqOuFEgEQLGcQCg5JxShuzdJDSKsBPt8vOeiC 4A/WUAoNTq
tty9EC1oR0iO+xWvpQEGpU7D
=G/th
-----END PGP SIGNATURE-----

BJ wrote:

Many Thanks for your reply and help.
In this instance, if I want to count the number of entries under "surname", I presume that the "Control Source" is "Surname" . I had inerted : =Count but the only this that appeared was the first entry (eg Smith) rather than a number. What function does the (*) serve?

Thanks
K
"MGFoster" <[e-mail]> wrote in message
news:oR*****************@newsread3.news.pas.earthl ink.net...

TextBox ControlSource: =Count(*)
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

BJ wrote:

Can anyone tell me how to include a count of group records in a group
footer. I know (I think I know!) that I have to include an unbound text

box

in the footer, but what expressions do I use to count the entries

within
a

group (subtotals I suppose).

eg: the column (group) headings are something like this:

Area Surname
London Smith
Giles
Davis
Harris

Total : = total number of surname entries

Manchester Jones
Jarvis
Coffey

Total : = total number of surname entries
What do I do to automatically count the "total number of entries" ?
Advice very welcome - Access isn't easy is it ?