H
help me
hey i m in trouble. i have one table with receiving inventory detail like
Itemno, description,receving quantity and another table contains sales detail
like itemno,description sales quantity. Now i wana to run a query which
should tell me how much quantity on hand i have. Now i ran two queries which
just sum the same items if we sold or receiving as many times. but now when i
run filter query for getting exact quantity on hand from minus receving and
sales query i am not getting right result. if i link these queries by item no
it just gives me item which i only sold. if i dont link them then it gives me
records duplicate .. i dont know wht to do
Itemno, description,receving quantity and another table contains sales detail
like itemno,description sales quantity. Now i wana to run a query which
should tell me how much quantity on hand i have. Now i ran two queries which
just sum the same items if we sold or receiving as many times. but now when i
run filter query for getting exact quantity on hand from minus receving and
sales query i am not getting right result. if i link these queries by item no
it just gives me item which i only sold. if i dont link them then it gives me
records duplicate .. i dont know wht to do