How to enter a group count in a header farther up

S

ShadwSrch

This is what I have:
Grade Level
.......Student Last Name <---Group header=yes visible=no
.............Student First name<---Group header=yes visible=yes
......................Discipline record type<---Group header=yes
visible=yes
....................................infraction date
....................................infraction date
......................Discipline record type 2
....................................infraction date
....................................infraction date

I want to enter a count for the total infractions next to the student's
full name in the First name header.

I understand the "=count$(*)" and I feel like that is going to be
involved, but I don't really know how to do this.

Maybe something with OnFormat and a variable that gets added to with
each infraction?

Any help would be appreciated
 
M

Marshall Barton

ShadwSrch said:
This is what I have:
Grade Level
......Student Last Name <---Group header=yes visible=no
............Student First name<---Group header=yes visible=yes
.....................Discipline record type<---Group header=yes
visible=yes
...................................infraction date
...................................infraction date
.....................Discipline record type 2
...................................infraction date
...................................infraction date

I want to enter a count for the total infractions next to the student's
full name in the First name header.


First, you do not want a separate group for last name.
Instead, use an expression that combines the first and last
names so you are grouping by student. Delete the Last Name
group and set your First Name group to:
=[Student Last Name] & "," & [Student First Name]

To count the detail records in a group, add a text box to
the group header and or footer section ans set its
expression to =Count(*)

The same expression can be used in the type group
header/footer to count the details for each type.
 
S

ShadwSrch

Thanks again, Marsh!

The solution was right under my nose...I had it in my first post, and
didn't know it...I missunderstood the * operator.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top