Results inconsistent as soon as I add a table in query

[onormandin]

Hello,



I'm building a very simple query that should display, for each product name, the quantity received, quantity returned (which are computed in the same query) and the quantity "actualized" (based on a separate query).

When I design the query, the results are multiplied by 4 when I add the table that should display "quantity actualized". It's really wierd, I mean, as soon as I show that table (or almost any other - but that's even stranger, cause it's not the same multiplier depending on the table), results are multiplied.

Help?

[orange]

It doesn't appear from the picture that you have joined the tables.
Can you go to SQL View in query design; copy the sql; then paste it here.