[AccessD] Formula for a calculated field

Oh well. I was afraid that was the answer. In SQL Server you can create a
calculated column which doesn't even physically exist. Oh well.

On 5/26/07, Stuart McLachlan <stuart at lexacorp.com.pg> wrote:
>
> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>