From form to table

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

DLookup and Nz 0
Access Form Refresh 1
Expressions: Table Fields & Forms 1
calculating averages 4
Using list boxes in a form to fill fields 1
DELETE FROM a table WHERE... 1
averages 1
how to refresh a query in subform 1

Back
Top