Bizarre problem with calculated control!

  • Thread starter Thread starter Sandra Grawunder
  • Start date Start date
S

Sandra Grawunder

I am creating a simple report. In my detail section I
have placed a control to add up values from several
columns. This control is named Nights, and it works
fine. In my group footer in want to place a control that
sums up the values of Nights within my group. Seems like
this should be

= Sum ([Nights])

It doesn't work, and I get an error message "The
Microsoft Jet database engine does not
recognize '[Nights]' as a valid field name or expression"

Humm...I can put another control within the detail
section using
= [Nights]
and it recognizes that OK? But if I put this control in
the footer section I get the same error message.

What gives here? What am I doing wrong?

Sandra G
 
You can't sum a control. You can often sum the control source of a control
from another section. For instance:
=Sum(Qty * UnitPrice)
 
Try creating a field called Nights in the report's base query with the
calculation that is in currently within the control. You should then be
able to use Sum([Nights]) in the header/footer.

HTH,

Kevin
 
Back
Top