calculating averages from form fields

  • Thread starter Thread starter Kit
  • Start date Start date
K

Kit

I'm new to Access 2007 and need to know if I can do an average on the
following fields from my Form:

My form name is Benton
I have three fields:
Field one is "Grade"
Field two is "Grade1"
Field three is "Grade2"
I want to do an average of Grade1 and Grade2 and put it in Grade
I want all of this done from my Form not from my Table nor from a Query, can
this be done this way.

I would prefer to use a macro but don't know how to create one outside of
the predefined macros.

Any help you can give me is greatly appreciated.

Thank you so much
 
Kit,

This is not a job for a macro.

I assume the 'Grade' control is not bound to any field in the form's
underlying table/query?

In design view of the form, in the Control Source property of the Grade
control enter like this:
=([Grade1]+[Grade2])/2

Just out of interest, what is your reason for saying you don't want to
use a query? In Access, queries are the most common tool for calculations.
 
Back
Top