[AccessD] Formula for a calculated field

Bill Patten bill_patten at earthlink.net
Sat May 26 10:19:44 CDT 2007


Arthur,

Why not connect the customers forms/ reports etc to a query with calculated 
fields?

Bill
----- Original Message ----- 
From: "Arthur Fuller" <fuller.artful at gmail.com>
To: "Access Developers discussion and problem solving" 
<accessd at databaseadvisors.com>
Sent: Saturday, May 26, 2007 8:15 AM
Subject: Re: [AccessD] Formula for a calculated field


I agree with you but the customer is always right, and to a certain extent I
will give her the benefit of the doubt. She wants to be able to filter the
form and various reports by these calculated columns, so she wants to see
them there in the table. Besides, we're probably going to upsize the app to
SQL Express fairly soon, where I can have the best of both worlds, i.e.
genuine calculated columns that consume no disk space but are logically
"there".

Your point is valid and I agree with you, but the customer wins in this
case.
A.


On 5/26/07, Jim Hewson <JHewson at karta.com> wrote:
>
> 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
>
> --
> 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