Access Tables

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.

Regards,

The Dingbat :confused:

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.

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

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