Join 2 Queries adding a column in Access

Posted on 2013-09-20
Medium Priority
Last Modified: 2014-06-09
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?

Question by:Elena Quinn
  • 3

Author Comment

by:Elena Quinn
ID: 39510564
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?
LVL 26

Expert Comment

ID: 39510813
Could you post a sample db (sanitized)?  (For my purposes, mdb is better.)

Accepted Solution

Elena Quinn earned 0 total points
ID: 40113208
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.

Author Closing Comment

by:Elena Quinn
ID: 40121484
No other solutions became avialable

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Article by: Tammy
MySQLTuner is a script written in Perl that allows you to review a MySQL installation quickly and make adjustments to increase performance and stability. The current configuration variables and status data is retrieved and presented in a brief forma…
If you need to implement application level security in an Access database application or other VBA code, I strongly encourage you to take advantage of Active Directory groups.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question