Sum query returning incorrect answer

[chawes40]

Hello,

I have two tables here is my first query Query2:

SELECT tashkil1.LIN, tashkil1.DESC, tashkil1.QTY, tashkil1.SMCO, Count(tbl_3.lin) AS linx
FROM tashkil1 LEFT JOIN tbl_3 ON tashkil1.LIN = tbl_3.LIN
GROUP BY tashkil1.LIN, tashkil1.DESC, tashkil1.QTY, tashkil1.SMCO;

This is my second query to get the sum for the qty but the addition is wrong:

SELECT Query2.LIN, Query2.DESC, Sum(Query2.QTY) AS SumOfQTY, Query2.SMCO, Query2.linx
FROM Query2


GROUP BY Query2.LIN, Query2.DESC, Query2.SMCO, Query2.linx;


Any help is appreciated!

[June7]

Can't see anything wrong with queries. Would have to examine data and test queries. If you want to provide, follow instructions at bottom of my post.