Search results

@plog Thank you very much for your help!

@plog, The query works perfectly! Wow...Thank you so much! This is exactly what I need ! May I please bother you a bit more. Can you please advise how I can build an update quiery ? It is my first time I have a deal with subquery.... I appreciate for your help. Does it look like that ? Update...

Hello @isladogs Not exactly, It doesn't need to update all zero values. The values gone after non-zero are needed to be updated for which fld1 is the same ID 4/5/6/7; fld1=30 ID fld1 fSum After update 4 30 0 0 5 30 100 100 6 30 0 100 7 30 200 200 8 40 0 0

Thank you very much for your kind and quick response. I am doing this task a whole week and I am ready to give up. This forum is my last chance :) There are 2 criterias ID and fld1 and based on them the data should be calculated. For instance: ID=4 has value 20 in the fld1. Totally, value...

Hello everyone and thank you for your support. I would like to know your opinion how can I update the field " fSum" and get the result as in table "AfterUpdate" - Criteria: ID and fld1 - Update field: fSum - Remark: I have 30 000 records in my table to be calculated InitialData id fld1 fSum...