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

calculate field

P: n/a
hii..i'm new here and dummies in access..i create one form that count total
salary.i have 3 field.let say a,b and c.c is auto calculate and will show the
total of a and b.my problem is when i look at table
there is no value in table c.anyone can help me..

--
Message posted via http://www.accessmonster.com

Dec 22 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
On Fri, 22 Dec 2006 04:43:40 GMT, nimda via AccessMonster.com wrote:
hii..i'm new here and dummies in access..i create one form that count total
salary.i have 3 field.let say a,b and c.c is auto calculate and will show the
total of a and b.my problem is when i look at table
there is no value in table c.anyone can help me..
The normal rule of Access is that you do NOT store calculated data.
As long as you have stored A and B in your table, anytime you need the
result of A * B, calculate it, in a query:

TotalAmount:[A] * [b]

or in an unbound control in a Form or Report:

= [A] * [b]

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Dec 22 '06 #2

P: n/a
i did a query but i dont know how to connect with field which is field C..i
need help

--
Message posted via http://www.accessmonster.com

Dec 28 '06 #3

P: n/a
On Thu, 28 Dec 2006 16:27:04 GMT, nimda via AccessMonster.com wrote:
i did a query but i dont know how to connect with field which is field C..i
need help
What do you mean by "connect with field"?
You don't connect with a field.
If you wish to call the query column C then:
C:[A] * [b]

You can then use [C] in a report or on a form. You do NOT store [C] in
a table.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Dec 28 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.