Pdeters
asked on
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
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
>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.
afaik no. I recommend doing this in the query that serves as your report's RecordSource, and then just adding/summing that field separately.
ASKER
How would I go about doing that.
ASKER
I have in the query
Month, Plan, Amount($amount
I do I pull out the sepate plans to sum them
Month, Plan, Amount($amount
I do I pull out the sepate plans to sum them
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ok - so for all the plans i would create a separate query and then create one that links them all together
ASKER
How would I create that 3rd query to link them ?
ASKER
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!
ASKER