Join 2 Queries adding a column in Access

Hi Folks,

I'm not sure if this can be done.   I have a crosstab report that shows dppm by category by month and it is dynamic in that it shows the last 6 months of data.  It's working great.  It was quite a haul to get there with all the queries I had to do and the union at the end to get the Gross and Usage Rows.  Here is what the data looks like now.

This is my data now.
What I would like to do is add a column to this that has the same models and categories, but the data would be cumulative.  Not a total of the 6 months, but since the beginning.

Here is what the new column looks like.

Separate data with column
So is there any way to join these two, so that I can make a complete report?

Thanks
LVL 1
Elena QuinnAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Elena QuinnAuthor Commented:
I'm sorry, I should be more specific.  I can make a simple select query from these two queries, and that will show me what I want to see - for this moment.  But since I need it to be dynamic, and one of these queries has specific dates for field names, how can I dynamically create this?  How do I make the SQL statement to dynamically call out field names?
0
jerryb30Commented:
Could you post a sample db (sanitized)?  (For my purposes, mdb is better.)
0
Elena QuinnAuthor Commented:
I made two Joined queries and then joined them together to solve this.  Sorry, it was a while ago and I forgot to close this.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Elena QuinnAuthor Commented:
No other solutions became avialable
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.