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

storing calculated value in table

P: 5
Hi all, I need your help i.e. I want to save some data to the respective table which is calculation in the FORM.
Feb 8 '07 #1
Share this Question
Share on Google+
3 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
Hi all, I need your help i.e. I want to save some data to the respective table which is calculation in the FORM.
You will need to provide more information about what you are calculating, how you are calculating it, where this code is placed and where you want to store the result.
Feb 8 '07 #2

nico5038
Expert 2.5K+
P: 3,072
In general calculated data isn't stored in a table.
When needed it's calculated in a query. This dies prevent erroneous calculations when the fields the calculated value is based upon does change....

Nic;o)
Feb 8 '07 #3

P: 5
I have 1 table (name=Billing) Where I store all kind of bill related data. I make a form by this table. In this form i make a calculation field (Difference in Rate =[AgreedRate]-[InvRate]) but it is not in the table.
"I want this calculated result (data) will be store in the table (name=Billing)."
Feb 17 '07 #4

Post your reply

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