ms-accessreport
MS ACCESS: Exclude a subtotal of a primary group from a grand subtotal
I've got a budget report that is broken down by category. Included in these categories is an OPTIONAL section. I would like to show the OPTIONALS in the main report but exclude them from the grand total. Everything works perfectly except I cannot figure out how to exclude (or subtract) the OPTIONALS. Please see attached image of design view of report. Thanks!
]1
Solution
It would be something like this:
=Sum(IIf(Category_Optional=True,0,Value))
Where Category_Optional=True is any kind of record expression that defined whether you want to exclude a record from the subtotal or not and value is the field you are getting a subtotal on.
- how to compare sql server data with MS Access data
- Create a query dynamically
- How can I get TSQL from easy MS Access SQL with little to no handiwork?
- How to refresh an access form
- MS Access - Can't Open Any More Tables
- Specifying Color of Columns in MS Access Histogram Chart
- In a standard MS Access SQL query output that does not have any aliases, how do I replace the full names by their "first-letters" aliases?
- How to create custom filter based on user input in MS Access
- Multiple users working from same application through ODBC corrupt ms access DB file. What is wrong?
- How to write criteria for query to return dates a year before current date
- c# Cannot open Database - Windows 10 Access 2016
- How to make a Report title dependent on a parameter?
- How select query from record count more than 1 and count more than 2 with custom column (Option) in MS Access
- How do I sort "SELECT INTO" queries that are built on top of each other by their "INTO" / "FROM" table links?
- Access database not closing properly
- How to open form to specific record from datasheet
- MS Access Expression Builder Value from another Table
- I'm getting an Error with my iff statement
- VBA "does not equal" code not stepping through IF statement as expected
- Access VBA For Loop throwing error of "No Current Record" after 1 iteration of code
- MSACCESS.EXE process won't end
- Adding an index to query result
- How can I make a search query disregard punctuation?
- VBA-Json Parse Nested Json
- Microsoft question regarding IIf statement or a better solution
- How select query from record count more than 2 with custom column (Option) in MS Access
- How do I enter a parameter to limit the results of a query using ADODB.connection & ADODB.Recordset using Excel VBA?
- How do I get my Mailmerge VBA routine not to show dialog box and to run automatically
- Sql TRANSFORM with calculation time in MS Access
- Dapper with Mapping by code: Multi-Mapping with repeating column names