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

Ken Moore psm2713 at hotmail.com
Mon Oct 10 14:51:14 CDT 2005

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.


FREE pop-up blocking with the new MSN Toolbar – get it now! 

More information about the thelist mailing list