Query to Multiply Values??? (1 Viewer)

[camaroltd82]

Hello again, I need a final bit of help in my dB. Two fields in my table are "unitcost" and "totalvalue". In the previous MS Works 3.0 program that I am updating from, any time the user updated the unitcost value, the totalvalue number updated automatically, as if there was a formula embedded in that cell. I know Access can do this, but I have to find a way to add this function in my tables, so at least I am not regressing from Works 3.0.

Thanks
Mike Fischer
camaroltd82@msn.com

 

[torok]

Calculated fields, as far as I know, have to go in a query. Basically, you're creating a View of your table that will include the calculated field, and you just use that as a table.

So make a query that has all your table values, then put a calculated field in the query that multiplies the unit cost * number of items. The field in the query designer will look something like this:

Total: unitcost * numberOfItems

and it will be of type "Expression"

Hope that helps...

 

[camaroltd82]

Thanks a lot, I get it perfectly now.