Search results

I have nothing else to say but that you are the GOAT. Thank you so much.

I applied it to my case like this: DSum(" [Montant_debit]","OPERATIONS","N_Operation<=" & [N_Operation]& " AND N_de_compte='" & [N_de_compte] & "'") AS DEB, DSum(" [Montant_credit]","OPERATIONS","N_Operation<=" & [N_Operation]& " AND N_de_compte='" & [N_de_compte] & "'") AS CRED, [CRED]-[DEB]...

Hi, thank you for your reply. In fact I came across a somewhat similar thread where you had responded with this solution: DEBRUNSUM: DSum("DEBIT", "TRANSACTIONS", "ID<=" & [ID] & " AND SUPPLIER='" & [SUPPLIER] & "'")

Hi, I am looking for help to solve a query problem. I have a table called OPERATIONS with the following fields : N_Operation (which is the ID of the transaction), N_de_compte (which is the ID of the account that initiated the transaction), Credit, Debit. So every user can make multiples...