By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,238 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

how insert calculated value in table from form view?

P: 1
I am new in access. Now I am using MS Access 2010.

Problem: I have table named customer with 6fields as follow
1. ID
2. Name
3. Received
4. Paid
5. Balance
6. Date

Field [3]+[4]=[5]
in [5] I have put a expression =[Received]-[Paid]
in view mood it showing result but not updating the table field balance. Just showing on form view

what can i do now?
Attached Files
File Type: zip (28.9 KB, 87 views)
Mar 16 '12 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 634

The Balance field in the table is redundant as the value is calculated (and can ALWAYS be calculated). It is good practice not to store data that can be calculated, except in certain circumstance (eg historical data).

The value is not shown in the table because the form's 'Balance' control is not bound to it (the Control Source is a calculation).

Mar 16 '12 #2

Expert Mod 15k+
P: 31,492
MTB's answer is right on the button, of course, but I thought I'd add a link to Database Normalisation and Table Structures, which appears to be necessary reading for you ;-)
Mar 16 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.