Hi Jeffrey, is this a question? I'm not sure what you're trying to say.

First I apologize for that trainwreck of a post.  I hate these meds I'm on for the next week or so.  Anyways I hate tables that are just loaded in 0's unless needed.  Same with forms.  I guess it's an OCD thing.  Much like Russ's approach I did conditional formatting and that worked.  Instead, after the meds kind of worked there way out of my system (for now) I went with the following in the query.

RunningBalance: Nz(DSum('Credit','CheckRegisterTbl','TranID<=' & [TranID]))-Nz(DSum('Debit','CheckRegisterTbl','TranID<=' & [TranID]))

I do realize that having running balances is going to slow things down as the table gets bigger. If I do have a question, it applies more to the double entry accounting video.  It's the I have 1 Debit applying to multiple Credits or the other way around.   What is the best way to approach it.  And yes - behind on my courses (viewing them at least).

That requires making something called a split transaction. It's not easy to code... and it's been on the list for a while now. You're person number 6 who has requested it. I'll bump it up the list.