Joining tables and records so everything comes together

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!
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

SQL_SERVER_DBAConnect With a Mentor Commented:
UNION your select statements to create on recordset
VBBRettAuthor Commented:
Can you please give an example?
SharathData EngineerCommented:
you have to provide the sample set. the sample data in your 7 tables and the expected result.
All Courses

From novice to tech pro — start learning today.