[AccessD] Column Formulae

Gustav Brock Gustav at cactus.dk
Sat Nov 26 09:11:19 CST 2005


Hi Arthur

I don't think you have any other option than using a query which includes your calculated field.
Whenever you need data from that table use the query as source.

/gustav

>>> artful at rogers.com 26-11-2005 15:51:57 >>>
In SQL, I can create a calculated column; i.e. ExtendedAmount = 1 + TaxRate
* (Quantity * Price).
Can I store said result in an actual column in Access (MDB)? Aside from the
fact that it's not a good idea to store calculations in columns, I am
retrofitting an existing db so I have limited choices here.
I have toyed with the default value attribute but so far have not had
success when attempting to reference other columns in the table.
So let me pose the question as simply as I can.
Given these columns:
Quantity    int
Price       currency
Extended    currency
Is there a way to make the value of Extended = Quantity * Price? I do not
want to do this in the front end. I want to do this in the table definition.
TIA,
Arthur





More information about the AccessD mailing list