Putting Total from different Query in a form

[Tuckejam]

Almost certainly going about this the wrong way but.....



I have table with all the data from my checking account register including "TransAmount" and "Reconciled" Note: Reconciled is a checkbox.

in the form that shows all of this data, at the top I Have the account balance which is all sum of all of the transactions.

But I want the total of all of the transactions that have "Reconciled" checked yes (this way i can match this total to what my bank account shows)


I created a new qry_BankBal that just has TransAmount and Reconciled summed and sorted to only show the sum on transacitons that have reconciled set to yes

How do get this number into my form.



as always, Thanks for the help

[Bob Fitz]

Try Following as Record Source of the text box:
=DLookup("SumOfTrans","qry_BankBal")

[Tuckejam]

Genius! Thank You!

[Bob Fitz]

Genius! Thank You!

Thank you for your kind words, but I can assure you that I am no genius. I am, however, always pleased to help if I can

[Welshgasman]

A DSum would have worked as well I expect?

[Bob Fitz]

A DSum would have worked as well I expect?

I'd be surprised if it wouldn't
Something like:

=DSum("TransAmount","YourTransactionTableName","Reconciled= -1")

Wouldn't need the query with DSum(), of course.