XP Access

[John]

I am trying to do a sum calculation in a form. The old
way of doing it on Access 1 to 1997 was to say =Sum
([field name]) This doe not work with XP Pro. Does anyone
have any idea?

 

[Allen Browne]

You should still be able to get the result using a text box in the Form
Footer section (not Page Footer) with Control Source of:
=Sum([field name])
provided that "field name" is a field in the form's recordsource (not a
calculated control on the form).

 

[John Vinson]

I am trying to do a sum calculation in a form. The old
way of doing it on Access 1 to 1997 was to say =Sum
([field name]) This doe not work with XP Pro. Does anyone
have any idea?

Sum([field name]) still works just fine in XP Pro, at least in my
databases!

What's the context? Where do you have this control on the form? Is
[field name] a correctly-spelled name of a field in the Form's
recordsource query?