adding up totals in query

[nightangel73]

Here is my dilema



I want to calculate total of sample withdrawn and returned


I built a query with that has the sum of withdrawn and sum of returned

well as long as it one record it works fine

Problem is when I go and do another withdrawn or returned transaction

then the sum of withdrawn doubles because it is now two transactions

if I add another withdrawal transaction the it sums three times and so on..

I want that it sums the total of withdrawn and total returned but I don't see how to get it right.


it goes 1st transaction received 300
2nd transaction withdrawal 50
3rd transaction withdrawal 25

because it is 3 entries it goes 50 +50+50, 25+25+25 I want result to be total withdrawn 75.

Please help I need to get this right!

[June7]

What is the data structure? Are multiple tables involved?

[nightangel73]

What is the data structure? Are multiple tables involved?

yes Product-order-order details.

the order details stores received quantity, withdrawn quantity and returned quantity

[June7]

So received, withdrawn, returned data are all in one table? Does each have its own field or do you have a field for transaction type and then a field for quantity? This is the structure I need explained.

Post the query you attempted.