calculate a total based on checkbox?

[Brook]

Good Day All,

I have a checking account form that I use for my business, and I have a
yes/no checkbox, and fields Debit & Credit.

What I am doing is setting up a reconciliation form so that when the
checkbox "Reconciled" is checked a total is calculated based on my Debit &
Credit Columns.

Can anyone assist me with this?

Thanks,

Brook

 

[Pete Dochers]

I'd try a total query that calculates whatever sum you want, with
criteriaOfchecked box = yes.

 

[Brook]

Hello Pete,

I tried the following calculation in my query but am getting #Error in my
text box on my form.. . any ideas?

IIf([reconciled]=True,DSum([DrCr],"[ID] <= " & [ID]))

Thanks,

Brook