simple question

  • Thread starter Thread starter Cletus Stripling
  • Start date Start date
C

Cletus Stripling

I really have never used Access and need to do something really simple
in the quickest way therefore posting here.

I have a table with the following fields:
Name (text)
Count (just a number)

I want to create a simple report that lists each name with a sum of the
count field. In the report, how do I add the field to quickly total the
count?

For example,
table
John Doe 10
Sue Smith 5
John Doe 3
John Doe 2
Kim Jones 1


report
John Doe 10
3
2
Sum 15

Sue Smith 5

Kim Jones 1
 
Open your report in design view. On the menu click on VIEW - Sorting and
Grouping. This opens another window. Click in the Field/Expresion grid and
select your name field. Then in the lower grid change Group Footer to Yes.
Close the Sorting and Grouping window.

In the group footer add a textbox with =Sum([YourValueField])
 
Thanks! Exactly what I needed!

KARL said:
Open your report in design view. On the menu click on VIEW - Sorting and
Grouping. This opens another window. Click in the Field/Expresion grid and
select your name field. Then in the lower grid change Group Footer to Yes.
Close the Sorting and Grouping window.

In the group footer add a textbox with =Sum([YourValueField])

:

I really have never used Access and need to do something really simple
in the quickest way therefore posting here.

I have a table with the following fields:
Name (text)
Count (just a number)

I want to create a simple report that lists each name with a sum of the
count field. In the report, how do I add the field to quickly total the
count?

For example,
table
John Doe 10
Sue Smith 5
John Doe 3
John Doe 2
Kim Jones 1


report
John Doe 10
3
2
Sum 15

Sue Smith 5

Kim Jones 1
Click to expand...
Click to expand...
 
Back
Top