calculated field

[rups1]

hi. i wanted to kno how to have a field in a table that is calculated from other fields if this is possible. for example i have a order table which has a quantity field and a price field and i want to add a total field that will alutomatically calculate the total (quantity*price) and add it to the field. i know how to do this in a query but don know how to get that field from the query into the table. thanks for any help

 

[MStCyr]

You can't have a calculated field in a table, however you can do this in a query.

 

[statsman]

It is never a good idea to have a calculated field in a table. The correct place to do calculations is in a query.
Do you calculation there and then use the query as the source for your form or report.