Opening Balance query (grab record above)

JurgenGeelen 

Hi Jurgen,
I think there is a difference in the comma and semicolon. This is why I have the syntax. Note I have replaced the semicolon with a comma in your formula above. I no longer have syntax. Also, I think I needed to replace "Valuta" with the word "Currency" to get the format correct.  It seems likely the differences are since we are in different countries. 

After making those edits, I think its very close but it needs to be tweaked a bit more and I have tried to modify to no avail.  Its far outside my knowledge of queries like this.  In the pic below, you can see what I am referring to.  I need the Closing Balance to be the Opening Balance in the row below it.  I hope it makes sense.  Thank you very much for the help, Jurgen.

Opening Bal Jurgen: Format(Nz(DSum("AmountofChange","tblLCAmendHistory","letterOfCreditID=" & [tblLCAmendHistory].[letterOfCreditID] & " And [ID] < " & Nz([tblLCAmendHistory].[ID],0)),0),"Currency")