From form to table

G

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.
 
A

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."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Form Refresh 1
calculating averages 4
Inserting totals from a form to a table 4
Pulling data from a linked SQL table 2
Future Date Calculation Expression 2
How to calculate form field 1
DELETE FROM a table WHERE... 1
Add Days from another table to Date in current table 4

Top