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

Calculated Field?

P: n/a
Hi
Would like to add a new Field to Table which is 75 % (or another
Percentage) higher than the Value in another Field in same Table.Is
this possible with Expression or would I have to enter the Values
manuallyTried to build a Query like this (successful) and then link
the new Field to the Query but was only able to do this as a Combo BOx
and not text field.
This is for a Products Page where I want to base the Retail Price on
the Cost Price
Any Help appreciated
Regards
Manfred
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Access / Jet (and, indeed, good relational design practices) do not support
calculated fields in tables. You should calculate the value in a query or in
a control on a form or report when the value is needed.

Larry Linson
Microsoft Access MVP

"Manfred" <ad***@cbdafrica.com> wrote in message
news:45**************************@posting.google.c om...
Hi
Would like to add a new Field to Table which is 75 % (or another
Percentage) higher than the Value in another Field in same Table.Is
this possible with Expression or would I have to enter the Values
manuallyTried to build a Query like this (successful) and then link
the new Field to the Query but was only able to do this as a Combo BOx
and not text field.
This is for a Products Page where I want to base the Retail Price on
the Cost Price
Any Help appreciated
Regards
Manfred

Nov 12 '05 #2

P: n/a
If this field should always be 75% of the other (and it would be wrong for
it to be anything else), then Larry is right. You need a calculated field in
a query instead of a field in your table. More information in article:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

If you want to start with 75% of the value and then be able to set different
values for different items, you do need the field in your table. Add the
currency field, and you can automatically populate it with an Update query:
1. Add the new field to your table.

2. Create a query into this table.

3. Change it to an Update query (Update on Query menu).
Access adds an Update row to the query grid.

4. Drag the new field into the query grid.

5. In the Update row under this field, enter:
1.75 * [Cost Price]

6. Run the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Manfred" <ad***@cbdafrica.com> wrote in message
news:45**************************@posting.google.c om...

Would like to add a new Field to Table which is 75 % (or another
Percentage) higher than the Value in another Field in same Table.Is
this possible with Expression or would I have to enter the Values
manuallyTried to build a Query like this (successful) and then link
the new Field to the Query but was only able to do this as a Combo BOx
and not text field.
This is for a Products Page where I want to base the Retail Price on
the Cost Price
Any Help appreciated
Regards
Manfred

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.