From form to table

[Guest]

Hello,
I have a form that will calculate all of my grade averages. Is there anyway
to get data from a form back into a table that already has an expression in
the control source field?
Any Help would be greatly appriciated.

 

[Al Campagna]

Jeff,
Given that you captured the grades into your table, it's not advisable to
store the average.
A general rule is... don't save a calculated value that can be
"rederived" from the elements already stored in your table.
You would, instead, recalculate the averages, "on the fly", in any
subsequent form, query or report.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."