By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,454 Members | 3,191 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,454 IT Pros & Developers. It's quick & easy.

Counting group records

P: n/a
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

Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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 ?

Nov 13 '05 #2

P: n/a
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" <me@privacy.com> 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 ?

Nov 13 '05 #3

P: n/a
-----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" <me@privacy.com> 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 ?


Nov 13 '05 #4

P: n/a
BJ
Many thanks again !

That did the trick

K
"MGFoster" <me@privacy.com> 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" <me@privacy.com> 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 ?


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.