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