[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.
Ken
_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/
More information about the thelist
mailing list