Access Report - Field to toal Group Totals

Hi,

I hope I have provided enough information for somebody to help me.

I have built an Access database that includes a table that contains
information that is input by the user via a user form. The user is asked to
input data in the following fields:-

1) Rec Area (Drop Down List (Worthing, Brighton, Shoreham etc.))
2) Agent Name (Drop Down List (Glenn, Joe, Wayne.))

I then have a query which groups the information by REC Area and the by
Agent Name it will then count by Agent name. I then have a report running
off the query. The report has a header which is the REC Area and then list
the names of all the Agent Names that have been input on that REC Area the
report will also count how many entries for that agent under that REC Area
(example below).

REC AREA - WORTHING
Glenn - 3
Joe - 2
Wayne - 2

REC AREA - BRIGHTON
Glenn - 2
Joe - 1
Wayne - 1

What I would like on my report is a field at the bottom of each REC Area
that totals the number of entries so under Worthing REC Area under Wayne I
want it to total so i would be 7 and unser Wayne in Rec Area Brighton it will
say 4.

Just having troubles doing the totals. Please can somebody help.

Thanks, Glenn

Have you tried displaying the group footer and adding a text box with a
control source like:
=Sum([Your Numeric Field Here])

--
Duane Hookom
Microsoft Access MVP


"Glenn" wrote:

Hi,

I hope I have provided enough information for somebody to help me.

I have built an Access database that includes a table that contains
information that is input by the user via a user form. The user is asked to
input data in the following fields:-

1) Rec Area (Drop Down List (Worthing, Brighton, Shoreham etc.))
2) Agent Name (Drop Down List (Glenn, Joe, Wayne.))

I then have a query which groups the information by REC Area and the by
Agent Name it will then count by Agent name. I then have a report running
off the query. The report has a header which is the REC Area and then list
the names of all the Agent Names that have been input on that REC Area the
report will also count how many entries for that agent under that REC Area
(example below).

REC AREA - WORTHING
Glenn - 3
Joe - 2
Wayne - 2

REC AREA - BRIGHTON
Glenn - 2
Joe - 1
Wayne - 1

What I would like on my report is a field at the bottom of each REC Area
that totals the number of entries so under Worthing REC Area under Wayne I
want it to total so i would be 7 and unser Wayne in Rec Area Brighton it will
say 4.

Just having troubles doing the totals. Please can somebody help.

Thanks, Glenn