Access '97 Sum Problem

[mattalin]

I am creating a report using Access '97 by referencing a query. I am able to show the data in the report from the query fine, however, when I try to use the "=sum()" expression in the ControlSource box I get the following error message: "Invalid Bracketing of name '[Headcount-Plan.Headcount]'" The strange part is I originally created the database in Access 2000 and converted it to '97 and the formula worked fine before.

The expression I have is: =Sum([Headcount-Plan.Headcount])

 

[Ziggy]

Try:

=Sum([Headcount]-[Plan.Headcount])

or

=Sum([Headcount]-[Plan]![Headcount])

=Sum([Headcount])-([Plan]![Headcount])


Ziggy

 

[mattalin]

"Headcount-plan" is the name of the query the report references and "headcount" is the data field so unfortunately your suggestions won't work.