By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,002 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 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 customer.zip (28.9 KB, 79 views)
Mar 16 '12 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 634
Hi

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


MTB
Mar 16 '12 #2

NeoPa
Expert Mod 15k+
P: 31,186
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.