Search results

ok..After researching and trying to use the Nz function, and researching and trying to use the Nz function(I tried several different times. lol), I tried another approach with the IIF function. IT WORKED! As a way to hopefully help others, I will show what I did: I built the query in design...

I will check it out. Thank you for your time!

I am new to this forum and to Access so I appreciate the opportunity to be able to ask you all a question. I am trying to create a financial statement. My tables are Chart of Accounts and GL Transactions. I have created a Trial Balance table where the beg bal, debit, and credit fields all have...