checking the next line...

[jk.]

hi everyone.. im stuck with this for whole week:banghead:

i have a query q_mkeA that i join tbl_A and tbl_B..

palletNum item code TotalQty OpenQty NewTotal
1 abc 100 50 50
1 abc 100 50 50
2 efg 500 100 400
2 efg 500 50 450

what i want to do is the next line can automatically change base on the NewTotal balance..NewTotal is from [TotalQty - OpenQty]..

is there a posobility to do it with query

 

[TexanInParis]

JK-

It's not clear what it is you want to do. I assume your example shows the data as it is now. Can you post an example of what you want the result to be?