Subtotal a cross tab Access report

Posted on 2013-05-31
Medium Priority
Last Modified: 2013-06-02
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.
Question by:smolbeck367
  • 2
  • 2
LVL 50

Accepted Solution

Dale Fye earned 2000 total points
ID: 39210838
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.

Author Comment

ID: 39211394
I will give a that a try. Thanks for the idea.

Author Comment

ID: 39214600
all set.
LVL 50

Expert Comment

by:Dale Fye
ID: 39214686
Glad that worked out for you.

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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.

Join & Write a Comment

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question