Solved

Joining tables and records so everything comes together

Posted on 2009-05-06
3
212 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 500 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

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

Suggested Solutions

Title # Comments Views Activity
SQL trigger 5 32
How to structure query with count aggregate 4 41
Problem with MySQL query - graph 3 23
Help with Progress 4gl Rounding Function 6 22
'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 …
If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

735 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