Summary Options with Report Wizard

  • Thread starter Thread starter a5wanman
  • Start date Start date
A

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
 
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.
 
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


a5wanman said:
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.
Click to expand...
 
Thanks for all the help. The Count(*) worked. I had trouble finding that
function in the help files and a book.

Scott


Duane Hookom said:
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


a5wanman said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top