Access 2003 - Report and subtotals of report

I have an Access 2003 database that I want a report to sub total by month and within that month subtotal certain parts

This is how the table set up
 These are the fiels  - Month, Plan, Amount($amount)
Want the report to show

Jan 2007
      Plan 1      $5,000
     Plan 3 + 4        7,000
    Plan 2               2,000
Month Total       14,000

Feb  2007
      Plan 1      $5,000
     Plan 3 + 4        7,000
    Plan 2               2,000
Month Total       14,000

Is there a way to pull certain plans out as a subtotal and then add them all together
PdetersAsked:
Who is Participating?
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
I think you'll have to create a separate query that does the sum, but with WHERE PLAN NOT IN(3, 4)  'or something like that

Then, create a third query which relates your original one and this one...
0
 
PdetersAuthor Commented:
All the plans are in one field
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
>Is there a way to pull certain plans out as a subtotal and then add them all together
afaik no.  I recommend doing this in the query that serves as your report's RecordSource, and then just adding/summing that field separately.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
PdetersAuthor Commented:
How would I go about doing that.
0
 
PdetersAuthor Commented:
I have in the query
Month, Plan, Amount($amount
I do I pull out the sepate plans to sum them

0
 
PdetersAuthor Commented:
ok - so for all the plans i would create a separate query and then create one that links them all together
0
 
PdetersAuthor Commented:
How would I create that 3rd query to link them ?
0
 
PdetersAuthor Commented:
Thank you - I got it figured out. I had to do a couple of queries and then put them together in another query and it work. Thanks for sending me in the right direction!
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.