• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1030
  • Last Modified:

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.
0
smolbeck367
Asked:
smolbeck367
  • 2
  • 2
1 Solution
 
Dale FyeCommented:
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now