=Sum() not working?

[Carl Foster]

I'm pretty new to reporting in Access so please bear with me

The report I have created consists of the report header and footer, 2 catagory headers and the page footer.

I have some info in one of the catagory headers that I would like to total for the report. I have used =Sum([curPrice]) in the control source of a text box of the report footer, where curPrice is the control source of the text box I want to sum up.

For some reason though it is calculating the total of a different text box contained in the detail section called curJobPrice. Why would it do this?

 

[elbweb]

try the DSum function and then have it be based off of the table, instead of the report, that should work..

 

[Carl Foster]

I ended up creating the sum in a query. This worked the way I wanted. thanks