An Odd Error

[lostsocks]

Howdy,
I'm trying to do something that should be fairly simple,
I have three fields in one of my tables
Price (Currency)
Quantity (number)
Total Price (Currency)



I want the default value of Total Price to be =[Quantity]*[Price] but whenever I add the formula I get the error message:

The Database Engine does not recognise either the field 'Quantity' in a validated expression or the default value in the table 'Orders'

I've tried changing the fields so that they are all numbers rather than currency, but this doesn't help.

I'm probably doing something absurdly silly and obvious wrong... but I can't for the life of me see what it is

[dcrake]

You do not store calculations in a table. You would use a query to represent them.

Qty:[Quantity]*[Price]

David