Hi 

I have a table (1) with numerical values in it I can sum these values to get the correct answer but when I join that table up with other tables that have more rows than Table (1)  the sum function will return the sum of all the rows in the query given an inflated answer.  

Eg if table (1) has 100 rows each with a numerical value of 2 the sum of table (1) is 200. If the query I create from Table (1) and Table (2) (which has 300 rows) the sum from that query for the numerical value is 600 (300 x2). With the table 1 values being counted more than once. 

Is there a way to get the 200 result from the query?

Any help is appreciated.