Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Joining tables and records so everything comes together

Posted on 2009-05-06
3
Medium Priority
?
229 Views
Last Modified: 2012-05-06
I am in need of some help.  I am trying to get 7 tables to work together so that I can do a summary of all the data in these tables.  All of the data is basically the same except I need to add the information together to create a quartly report.  The report has to be in Excel but all the data resides in Microsoft Access.  Does anybody have a clue as to how I can do this?  Please let me know.  Thanks!
0
Comment
Question by:VBBRett
3 Comments
 
LVL 16

Accepted Solution

by:
SQL_SERVER_DBA earned 2000 total points
ID: 24320057
UNION your select statements to create on recordset
0
 

Author Comment

by:VBBRett
ID: 24323749
Can you please give an example?
0
 
LVL 41

Expert Comment

by:Sharath
ID: 24339455
you have to provide the sample set. the sample data in your 7 tables and the expected result.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

'Between' is such a common word we rarely think about it but in SQL it has a very specific definition we should be aware of. While most database vendors will have their own unique phrases to describe it (see references at end) the concept in common …
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses
Course of the Month8 days, 2 hours left to enroll

824 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