Has anyone been able to create a total for an unbound field in a report? It's frustrating to see the great numbers in the detail section but not be able to add them up at the end of the report!

Thanks for any help you can give!

you could try setting a variable in the OnPrint event for the Detail Section:

TotField = TotField + me.Field1

then set use this value in the OnPrint event of the Report Footer:

me.TotAmount = Totfield

I can't say that I've gotten this to work exactly but I think it has some potential. You have to declare TotField as a global variable so that you can refer to it from different procedures.

Denny