Can i use the result of a Dlookup expression for a calculation

[annakalli]

Hi,
i have a report that imports a number with the dlookup function from one table, and i want to use that number in a calculation, is that possible?

[Stewart Ross]

Hi annakali. You will need to repeat your DLookup for your calculation, as you will likely find that you cannot use the value previously looked up and placed (I would guess) on an unbound textbox control on your report.

An approach which provides better flexibility is to base your report on a query which includes joins to the table or query you are looking up, or, if this is not possible, to include the DLookup in that recordsource query instead. You will then be able to refer to the value by including a control on your report bound to that field.

-Stewart

[annakalli]

Hi Stewart,
thank u for ur advise, however my exact problem is the following.

I create a report, grouped by the customer code to display for every customer , his opening balance which i retrieve with the dlookup function from my table called accounts and i placed it in the customer code header, and in the details section i have the fields : date, transaction, debit, credit, and balance. I create the balance field through a text box with a running sum, and assign the control source property as follow
=[cramount]-[drAMOUNT]+DLookUp("[opening balance]";"accounts";"[Accountnumber] = " & "'" & Reports!customers_statements!customercode & "'")

Imagine something like ur bank statement. The problem now is that, in the first row of the data i get the correct balance but in the rest ones is wrong because is adding again the opening balance, so i thing i need to enter a code dealing with a counter, and when my counter is >1 (after the first row) then no to add the opening balance. Unfortunatelly i dont know how to do it.
I would be thankful, if u can help me.