Is it possible to use a formula in a field to calculate Qty

[mcnaught]

Hi
I'm trying to setup a simple database to test if this idea will work in
Access and have run into a wall.

I have 3 Tables

Client:
(CID), Surname, A, B
1, Smith, 5, 3

Component:
(CompID), Description, Qty, Price, Formula
A001, A1 desc, ,$10, =A
A002, A2 desc, ,$20, =B
A003, A3 desc, ,$30, =A*B

ClientComp:
(CID, CompID), Description, Qty, Price, Formula
1, A001, A1 desc, 5, $10, =A
1, A002, A2 desc, 3, $20, =B
1, A003, A3 desc, 15, $30, =A*B

How can I get the ClientComp table to make use of the formula and
populate the Qty field. Can this be done in a query or a module?

Is there a better way?

 

[mcnaught]

I agree but in this case there are a number of factors that "may"
change the quantity. So the calculated quantity is just a starting
point that I want the user to be able to change.