totaling columns in Access

[velma_b]

I have a report with three columns: "Curr Ln Amt", "Max Ln Amt", and "Refund". The "Refund" column has this for the control source: =[curr ln amt]-[max ln amt]. That works fine. I'm having a problem totaling the results of "Refund". I put a text box in the report footer: first using " =sum([refund])" and then " =sum([curr ln amt]-[max ln amt])" as the control source . Both returned "0". How can I get a bottom line total from a column with a formula as the control source? Thanks for your help.

 

[SydneyGeek]

Hi Velma, try
=Sum([curr ln amt])-Sum([max ln amt])

Denis