Sum a field

[alman123]

ok i have a report in which i want to sum a certain field. the field itself is calculated. i have Sumed the field but it does not give me the right numbers. if i do running sum it does at the end. but i only want to see the final number. how can i do this. is there a way that it will show only the final number. i have tried many things. such as trying to do it in a query. that wont work because it does not add everything. also i have put the sum fomula all over the report, in the footers, headers, detail. nothing seems to work

 

[jsteph]

If the field itself is calculated, you should calc it in the underlying query, not the report. Then put a Sum([that field]) in the footer, then name the footer sum field, say, txtGrandTotal. Then reference =txtGrandTotal as a controlsource in a field somewhere else.
--Jim