Creating a Running Balance Query

[GPGeorge]

I used Duane's version. My version gave the same amount on each record

So, that would be "Yes, Duane's version raised the error?"

 

[Gasman]

Upload a DB so show the issue.

 

[DHookom]

You could try several troubleshooting steps. I would first open the immediate window (press Ctrl+G) and enter the following with a good account and valid ID.
?Val(DSum("Nz(Debit,0)-Nz(Credit,0)","qryCheckRegister","[Account] = '[known legitimate Acct]' And ID <= 1000')

If it works, try the query with above expression.
If it works, add a new column to the query
test: [Forms]![frmBankAccounts]![Account]
If you see correct value from the form, consider providing a sample database with just the required objects.

 

[Gasman]

TBH I am surprised that (DSum("Nz(Debit,0)-Nz(Credit,0)", works.

 

[AngelSpeaks]

So, that would be "Yes, Duane's version raised the error?"

Yes

 

[AngelSpeaks]

Upload a DB so show the issue.

Working on it.