[Year 12 IT Apps] Access qn..

[Mike Brookes]

Hi All
The reason why Access won't let you put a calculated field in a table is 
probably because it isn't considered Kosher to store data in a table 
that can be calculated from other fields in the database hence making 
the field redundant.
The accepted method is to use either a calculated field in a query if 
your form/report is based on more than one table or as a textbox in the 
form/report with the control source property set to the appropriate 
expression.

Mike Brookes
Chief cook and bottlewasher Copperfield college

Jock Garnsworthy wrote:
> Kent,
> As far as I know, and have ascertained over the years, Access will not 
> allow a calculated field in a table. Hence it must be done via a form or 
> a query. Must admit I haven’t had this confirmed or denied by an Access 
> Guru as yet !
> 
> Cheers,
> 
> Jock
> __________________________
> Jock Garnsworthy
> Pasco St.
> Williamstown High School
> (03)93971899
> 
>