Function error

[DataMiner]

Hi,
I want to do some last-minute calculations to format a field in my report. The field in question is used in detail section of the report, and then summed in the header, like so:

Header: =sum([Stagestd]/24)

Detail: =[stagestd]/24

The header section works fine, but all the records in the detail section show an error. If I try to use ANY type of formula in the detail section, I get an error. If I just leave the detail section set to "stagestd" it works OK, but I can't seem to process this value in any way without an error.

If I move these calculations back to the query which is the report's recordsource, I can make this work. But for various reasons I don't really want to do this.... WHY doesn't this work??? Is it just another one of those nebulous corruption deals, or what?

Access 2002

Thanks for any clues you can provide

 

[Pat Hartman]

The problem is that the control in the detail section with the calculation is named with the name of the field it was originally bound to. Since replacing the name of a field from the RecordSource with a calculation makes the control unbound, you MUST also change the Name of the control so that it will not be the same as any field in the form's RecordSource. The Name property is on the Other tab of the property sheet.

 

[DataMiner]

Thanks Pat! You are so good!