Functions in Access

[Neil Greenough]

I have a few different costs in a table in an Access DB.

In one box, I have a value of £300. Now what I want is for in another box,
for it to automatically work out 10% of this and then autofill the amount in
that field, ie £30 in this case.

How do I go about it? Do i do this in the form or in the table?

 

[Arvin Meyer]

You can't do it in a table, you can do it in a query or, if the form is
based directly on the table, you can do it in the form.

Query:
Expr1: [txtValueField]*0.1

Form controlsource:
=[txtValueField]*0.1
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access