HOW TO GET BALANCE WITH TWO QUERIES MATCHING FIELDS

[Shafique]

HELLO EVERYONE

here i am creating a balance query
i have a query named [GRADINGPRDQRY] where i get some a total in GRQTY
and another query [BUNDLEQRY] where i use some items using query [GRADINGPRDQRY]'s ID
here i want to create a query that show all the records form [GRADINGPRDQRY] with every ID's [GRQTY] BALANCE

 

[welshgasman]

If the qtys are linked, can't you just sum the value from the other table?
You would need to qualify which ID you are talking about in = [ID]

 

[Shafique]

well
i am learning a lot of things via this platform. this is same like helping peoples who are effected with a flood disaster.
so guide me the way how to get balance of GRADINGPRDQRY's GRQTY According its ID
please send me the right expression to get Balance

 

[welshgasman]

this is same like helping peoples who are effected with a flood disaster.

Probably could just use Sum(GRQTY) - Sum(QTY) with matching ID against GRID

I generally have to actually use the QBE to get my synatx correct, then perhaps amend to suit.

Break it down into small steps. Get one sum, then the other, then subtract. Small steps, one at a time.