[AccessD] Formula for a calculated field

Stuart McLachlan stuart at lexacorp.com.pg
Sat May 26 08:48:44 CDT 2007


AFAIK, you can't do that in the actual table, you can only do it  by 
setting the DefaultValue of a bound control on a form to a function using 
other bound controls (and the other controls must be before that one in the 
tab order)

On 26 May 2007 at 9:09, Arthur Fuller wrote:

> In an Access table, I want the formula for column C to be A/B where A and B
> are columns. I put A/B in the default value slot for C but that doesn't
> work. I prefaced it with an = sign but that doesn't work either. I'm certain
> that I have done this before but I can't remember how I did it. Help?
> 
> TIA,
> Arthur
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com





More information about the AccessD mailing list