[AccessD] Calculated Fields

[Charlotte Foust]

SQL Server had triggers too, while Access only just acquired data macros to
serve some of the same purposes.  I haven't used them in Access or SQL
Server because to me they totally violate normalization.  They're really
data warehousing/reporting tools that have been grafted onto databases and
in Access they can be easily misused by people who don't know how to
program events.  Their use in Access is, I think, aimed at web-based
solutions.

Charlotte Foust
(916) 206-4336

On Mon, Jun 15, 2015 at 12:42 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> SQL Server has always had calculated fields.
>
> Susan H.
>
> On Mon, Jun 15, 2015 at 3:35 PM, Heenan, Lambert <Lambert.Heenan at aig.com>
> wrote:
>
> > I had not realized that feature was even there. I'm pretty sure I will
> > ignore it and never create such a field, I prefer to do calculations in
> > queries and code where they normally happen and where I expect to look
> when
> > I have problems to fix. I would hate to spend hours scratching my head
> only
> > to find that this strange hybrid "data type" was the cause of a problem.
> >
> > There is also no equivalent in Oracle. I wonder if SQL Server has it.
> >
> > Lambert
> >
> >
> >
> > -----Original Message-----
> > From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
> > Susan Harkins
> > Sent: Monday, June 15, 2015 12:35 PM
> > To: Access Developers discussion and problem solving
> > Subject: [AccessD] Calculated Fields
> >
> > Are any of you using the new Calculated Field data type -- I guess it
> > isn't strictly a data type, but I think that's how Access is defining it.
> >
> > Susan H.
> > --
> > 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
>