Query Results being Multiplied

[E1202413]

I am trying to link multiple tables to show in one output but sometimes the numbers are being doubled, tripled or more. It is not on every line only some.

SELECT [CER Master List].[Approved/Closed], [CER Master List].[CER #], [CER Master List].Description, [CER Master List].Date, [CER Master List].GBU, [CER Master List].Location, [CER Master List].[CER Contact], [CER Master List].[Budget Amount], Sum([2014 Assets YTD].Amount) AS SumOfAmount, Sum([2014 GL Detail].Amount) AS SumOfAmount1, Sum([2014 YTD Capital Co 60].[updated amount]) AS [SumOfupdated amount], Sum([2014 YTD Assets Co 60].[updated amount]) AS [SumOfupdated amount1]
FROM ((([2014 Assets YTD] RIGHT JOIN [CER Master List] ON [2014 Assets YTD].SLN = [CER Master List].[CER #]) LEFT JOIN [2014 GL Detail] ON [CER Master List].[CER #] = [2014 GL Detail].SLN) LEFT JOIN [2014 YTD Capital Co 60] ON [CER Master List].[CER #] = [2014 YTD Capital Co 60].SLN) LEFT JOIN [2014 YTD Assets Co 60] ON [CER Master List].[CER #] = [2014 YTD Assets Co 60].SLN
GROUP BY [CER Master List].[Approved/Closed], [CER Master List].[CER #], [CER Master List].Description, [CER Master List].Date, [CER Master List].GBU, [CER Master List].Location, [CER Master List].[CER Contact], [CER Master List].[Budget Amount];


I am taking some base data and retreiving amounts from 4 different tables. See the first line for #100323 this should be $21,700 and $2212.49.
But #100782,101016,101352...etc are all correct. Any help??

[June7]

This happens when query includes multiple tables that are the 'many' side of a relationship to another table.

Need to do aggregate queries on the 'many' side tables first. Then join those queries to the 'master' they relate to.

[E1202413]

Sorry...I'm new at this? How exactly would I do this? Thanks

[June7]

Use the query builder. This is basic Access functionality. Access Help has guidelines for using the query builder and building aggregate (Totals GROUP BY) queries. There are lots of tutorials on the web. I don't want to write a tutorial here in post. For a start review http://www.opengatesw.net/ms-access-...ess-Query2.htm

Build and save query objects then use those queries like tables in another query.

[E1202413]

I didn't know I could use a query as a table. This works now. Thanks for the help!