Microsoft Access Forum

Forums

Microsoft Access Forum

This forum is for the discussion of Microsoft Access.

Access is my personal specialty. Have questions? Comments? Want to discuss how to do something? Post it here. Also, I get a LOT of questions sent to me in Email from people around the world. I'll post the interesting ones in here. Feel free to comment on them.

Click Here To Subscribe to this forum and receive an email update whenever new posts are added, just scroll down to the bottom of this page and enter your email address in the comment form.

Permanent Link
Keywords: microsoft access forum

Post New Topic

Read Storing calculated values by Irfan @ 5/11/2012

I have built a form and in a field i put a formula for calculating GSM, GSM is calculated but not save in Table. What i do?

Reply from Richard Rost:

Values that are calculated on a form in a form field are not stored in the underlying table. Most of the time, you don't need them to be. When you're calculating, for example, PROFIT = SALES - EXPENSES, you don't need to store that value because you can always use a form or calculated query field to recalculate it on the fly.

However, if you want to store that value in the field for any reason, you can... but you'll have to make a field for it in your underlying table, bind that form field to it (set the ControlSource), and then you'll either need some VBA with an AfterUpdate event to SET that value OR you can use Access 2007's new Calculated Field data type. I'll be covering the latter in an upcoming class.

Show Just This Thread Post Reply

Collapse All Topics

Post Your Comments or Subscribe
If you would like to be notified of new posts on this forum,
just enter your email address below. It will be kept private.

If you just want to subscribe to get email updates when this forum is updated, then enter your name and email address and check the Notify Me box below. If you would optionally like to add your comments below to be posted, they are welcome.
Your Name:	Shown
Your Email:	NOT Shown
Subject:
Comments:
	Sorry about this step. It's just to keep the spam bots away:
Verify:	What is 5+2:

	Notify me when the this forum is updated
	Remember Me for my next comments


Please do not use this form for Customer Service inquiries! If you have questions about your account, shipping info, courses you've ordered, need passwords, etc. please use the Customer Service Center instead. I value your comments. They will be displayed on this page (above). Your name will be displayed, but your email address will not be. As always, I promise to never give away your personal information to anyone else, ever.