Summary Options with Report Wizard

[a5wanman]

I'm reading a Mastering Access 2000 box from Sybex. An example of the
report wizard shows a Summary Options button on the sort order screen (after
the grouping screen). However, I do not have the Summary Options button.
How do I turn on that button? I'm using Microsoft Office 2000 Premium.

Thanks,

Scott

 

[Duane Hookom]

Does your report have any numeric fields in its record source?

 

[a5wanman]

No. I was hoping to use a summary feature to count records. I didn't know
that a numeric field was required for the "Summary Options" button.

Here's what I'm trying to do:
my data contains the following fields:
last name first name date of birth model sex race
disability code age

I would like to create a report that show the above grouped by:
1st age
2nd disability code
3rd race
4th sex
5th model

The other student information should then be listed.

Example the report should look similar to:

Age: 3
Disability: AUT
Race: W
Sex: F

Name Date of Birth Model
Jon Doe 1/1/2003 SC-2
Jane Doe 7/7/2002 SC-2

# Students: 2

Disability: OI
Race: W
Sex: M

Name Date of Birth Model
Wile E. Coyote 1-1-1945 SC-2

# Students: 1

# Students this
Age: 3


I would like to count the number of records in 2 different places. I am
able to get the count for each model, but I'm having trouble getting the
total count for all students in the age group. I have added a field named
AgeCount in the detail field, then in the Age footer, I added a text box
with the control source as =[AgeCount].

The results I'm getting keeps a running total of all students. For
instance, the first "Students this Age" count is correct. The next
"Students this Age" contains all students. I would like the age count to
only have the count within that age.

Any help would be greatly appreciated.

 

[Duane Hookom]

Have you set up your sorting and grouping according to your needs? You can
count the number of records in any group by adding a text box in the group
header or footer with a control source of:
=Count(*)
To count records that are not grouped together, I recommend creating totals
queries and then using these as the record sources of subreports.

--
Duane Hookom
MS Access MVP

No. I was hoping to use a summary feature to count records. I didn't know
that a numeric field was required for the "Summary Options" button.

Here's what I'm trying to do:
my data contains the following fields:
last name first name date of birth model sex race
disability code age

I would like to create a report that show the above grouped by:
1st age
2nd disability code
3rd race
4th sex
5th model

The other student information should then be listed.

Example the report should look similar to:

Age: 3
Disability: AUT
Race: W
Sex: F

Name Date of Birth Model
Jon Doe 1/1/2003 SC-2
Jane Doe 7/7/2002 SC-2

# Students: 2

Disability: OI
Race: W
Sex: M

Name Date of Birth Model
Wile E. Coyote 1-1-1945 SC-2

# Students: 1

# Students this
Age: 3


I would like to count the number of records in 2 different places. I am
able to get the count for each model, but I'm having trouble getting the
total count for all students in the age group. I have added a field named
AgeCount in the detail field, then in the Age footer, I added a text box
with the control source as =[AgeCount].

The results I'm getting keeps a running total of all students. For
instance, the first "Students this Age" count is correct. The next
"Students this Age" contains all students. I would like the age count to
only have the count within that age.

Any help would be greatly appreciated.

 

[a5wanman]

Thanks for all the help. The Count(*) worked. I had trouble finding that
function in the help files and a book.

Scott

Have you set up your sorting and grouping according to your needs? You can
count the number of records in any group by adding a text box in the group
header or footer with a control source of:
=Count(*)
To count records that are not grouped together, I recommend creating totals
queries and then using these as the record sources of subreports.

--
Duane Hookom
MS Access MVP

No. I was hoping to use a summary feature to count records. I didn't know
that a numeric field was required for the "Summary Options" button.

Here's what I'm trying to do:
my data contains the following fields:
last name first name date of birth model sex race
disability code age

I would like to create a report that show the above grouped by:
1st age
2nd disability code
3rd race
4th sex
5th model

The other student information should then be listed.

Example the report should look similar to:

Age: 3
Disability: AUT
Race: W
Sex: F

Name Date of Birth Model
Jon Doe 1/1/2003 SC-2
Jane Doe 7/7/2002 SC-2

# Students: 2

Disability: OI
Race: W
Sex: M

Name Date of Birth Model
Wile E. Coyote 1-1-1945 SC-2

# Students: 1

# Students this
Age: 3


I would like to count the number of records in 2 different places. I am
able to get the count for each model, but I'm having trouble getting the
total count for all students in the age group. I have added a field named
AgeCount in the detail field, then in the Age footer, I added a text box
with the control source as =[AgeCount].

The results I'm getting keeps a running total of all students. For
instance, the first "Students this Age" count is correct. The next
"Students this Age" contains all students. I would like the age count to
only have the count within that age.

Any help would be greatly appreciated.

Does your report have any numeric fields in its record source?

--
Duane Hookom
MS Access MVP


I'm reading a Mastering Access 2000 box from Sybex. An example of the
report wizard shows a Summary Options button on the sort order screen
(after
the grouping screen). However, I do not have the Summary Options button.
How do I turn on that button? I'm using Microsoft Office 2000 Premium.

Thanks,

Scott