[AccessD] Formula for a calculated field

Jim Hewson JHewson at karta.com
Sat May 26 10:04:36 CDT 2007


I'm just curious, why would you want to do that?
Why would you want a calculated field in the table?
All the calculating I've done has been either in a query / view or on the form or on the report.   
Thanks.

Jim 
jhewson at karta.com
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Saturday, May 26, 2007 9:44 AM
To: Access Developers discussion and problem solving
Subject: Re: [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
>
-- 
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