Averages . . . still stumped

B

Benay

=Avg([total])

The name of my field is "Total". Above is copied an
pasted from the control cource under the data tab in
properties of my text box. It gives me "error#"

Signed,

Frustrated in Phoenix
 
J

John Vinson

=Avg([total])

The name of my field is "Total". Above is copied an
pasted from the control cource under the data tab in
properties of my text box. It gives me "error#"

Signed,

Frustrated in Phoenix
Click to expand...

Note that the textbox *MUST* be on the form (or subform's) Footer, not
on the body of the form itself.

Total is probably a reserved word - you might try renaming the field.
 
Top