Need to add a DLookup Formula to another total on an Access Report

[Stayingahead]

I am trying to get an Access Report resembling a Bank Statement. I had to developed two queries, 1-a balance of all transactions prior to the month the report is for, and, 2-a detailed list of all transactions that occured in the month the statement is for. THe report is sorted by the Clients name and has a page break between Clients. I am able to pull the Prior month total by using a DLookup formula. Also, I get a detailed list of transactions with a total for those detailed transactions.
I am having problems trying to add together the DLookup total and the total for the current month for a page footer. The formulas are as written:
DLookup formula: =DLookup("[SumOfBeg Balance]","[Client PRS Acct Beg Balance for Bank Statement]","{Client ID=Reports![Client PRS Bank Statement].[Client ID]")

Current Trans Total: =sum([Balance])

How would my formula read to add these two together?

 

[Terpsfan]

Did you create an unbound text box and put in the control source

=DLookup("[SumOfBeg Balance]","[Client PRS Acct Beg Balance for Bank Statement]","{Client ID=Reports![Client PRS Bank Statement].[Client ID]") + sum([Balance])