[thelist] MS Access: Creating a default calculated field?

[Ken Moore]

Hi, all


>Frank Marion noted:
>
>
>I want to whip up a quick database, where one of the **fields** has a
>default that is a calculation, or that the calculation is automatically
>triggered when data is entered.
>

Having a calculated field is almost always a mistake. About the only time I 
would do that is with very high traffic - on the web, network, or the app. - 
and if it takes long time to calculate it.

That should not be a problem, tho. Almost everything I do is with the 
queries on a table and not the table itself. Create a field in the query 
like this: NetAmt:[GrossAmt]-[TotTax] where GrossAmt and TotTax are other 
fields of the table.

Ken

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar – get it now! 
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/