How do I show the grand total which excludes one sub-account.

Art Carino 0 Reputation points
2026-07-14T03:43:50.1766667+00:00

Report displayed

Sub 1

  item1                   20.00

  item 2                 25.00

        Total Sub1 =  45.00

Sub 2

 Item 3                   10.00

 Item 4                   15.00

        Total Sub 2     25.00

Sub 3

 Item 5                    10.00

 Item 6                    10.00

        Total Sub 3      20.00

Grand Total 90.00

Total without Sub 3 70.00 How to calculate this item?

Microsoft 365 and Office | Access | For home | Windows
0 comments

1 answer

Sort by: Newest
Most helpful Newest Oldest
  1. Duane Hookom 26,935 Reputation points Volunteer Moderator
    2026-07-14T03:51:12.74+00:00

    What value/field in your record source determines which values aren’t included in you final total? Can you provide some field names? Assuming field names Sub and Amt, you could try:

    =Sum([Amt] * (([Sub]=3) + 1))

    this should work since ([Sub]=3) is -1 when true and 0 when false. Using +1 changes -1 to 0 and 0 to 1.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.