View Full Version : Access Tables

03-19-2004, 10:20 AM
In an Access table how can I calculate in a field. That is, in the retail price filed how do I calculate "cost * %?

I feel sure that one of you guys will have the answer.


The Dingbat :confused:

03-19-2004, 02:24 PM
It is easier to do the calc in a query. Then either use the query to display the calculated cost or input it into the table field. Using a query the calculation would look like:

Cost:[Fieldname] * .96

This will give you a calculated field named cost which is 96% of Fieldname.

Heero Yuy
03-22-2004, 04:07 AM
i agree with cinci he has a point or you can do it a couple of other ways but he just told you the easiest one

03-22-2004, 06:56 PM
Thanks guys. I was having a problem creating a form from a query so I did the calculation with a macro. It was a long way round the problem but it achieved some other solutions.

I do appreciate your assistance though.

With kind regards,

The Dingbat. :)