[AccessD] SUM-ing results of a DateDiff Operation in a report?

Gustav Brock gustav at cactus.dk
Fri Feb 27 12:33:34 CST 2004


Hi Christopher

Looks like AverageGap is a calculated textbox.
Try:

  =[BlockGapSum]/[ItemCount]

But where did [BlockGapSum] come from?
Shouldn't it be [TotalGap]?

/gustav


> THE PROBLEM:

> Now, it's time to divide to get an average.  I put a field named
> AverageGap in the Technician's footer, with the ControlSource
> "[BlockGapSum]/[ItemCount]".  When I run the report, this field
> displays #Name!.

> Usually, I only see #Name! if there is no data for a given field. 
> But I have all the elements tha the AverageGap field needs - the
> calculation in AverageGap simply isn't working, and I'm not sure why.

> Ideas?

> -Christopher-




More information about the AccessD mailing list