Subtotal a cross tab Access report

Hi, I am looking for way to add a subtotal row to a cross tab Access report. There are 9 rows on the report currently. This is made up of 8 rows of info and 1 total row. I need to add a subtotal row after the first 3. This report is being created dynamically based on two form inputs. Thanks for the help.
smolbeck367Asked:
Who is Participating?
 
Dale FyeConnect With a Mentor Commented:
Best way to do this is to add a computed column to the cross tab query as a row header.  The computation for this would test the value of the field(s) you are currently using as your role headers and assign a value of 1 to the first three rows and a value of 2 to the other rows.  You can use nested IIF() statements or the Switch function o do the tests.

Then, in the report you group by this column and add a footer to the group.
0
 
smolbeck367Author Commented:
I will give a that a try. Thanks for the idea.
0
 
smolbeck367Author Commented:
all set.
0
 
Dale FyeCommented:
Glad that worked out for you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.