Link to home
Start Free TrialLog in
Avatar of Elena Quinn
Elena Quinn

asked on

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.

User generated image
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.

User generated image
So is there any way to join these two, so that I can make a complete report?

Thanks
Avatar of Elena Quinn
Elena Quinn

ASKER

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?
Could you post a sample db (sanitized)?  (For my purposes, mdb is better.)
ASKER CERTIFIED SOLUTION
Avatar of Elena Quinn
Elena Quinn

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
No other solutions became avialable