|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 14th, 2006, 07:53 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Expression in Table
I am designing a table with the following fields: Units, Price and Worth.
Worth = Units*Price When stting up the table can Worth have a Default Value of =Units*Price? Tried that and I am getting an error message. Do I have to create a query and do the calculation there.? Thanks in advance for your help. 
|
|
#2
August 14th, 2006, 08:17 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Expression in Table
Hi,
yes...as a general rule you do NOT want to store calculated values in tables. Instead they can be calculated at runtime as needed in queries or on forms/reports. HTH Good luck -- Oli-S Admin Specialist & Computer Science Major @ UMD - Go Terps -  http://www.oli-s.de "Emile" wrote: I am designing a table with the following fields: Units, Price and Worth. Worth = Units*Price When stting up the table can Worth have a Default Value of =Units*Price? Tried that and I am getting an error message. Do I have to create a query and do the calculation there.? Thanks in advance for your help.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
