Access 2007 expression in a table

  • Thread starter Thread starter RChamp1969
  • Start date Start date
R

RChamp1969

I am struggling with Access 2007, trying to teach myself how to build an
expression in a table. My table is a listing of customers, names, address,
the last field I want to put in is "Preferred_Customer", I want this to look
at the "YTD_Orders" and see if it is >= 10000, if so then Yes if not No.
 
I am struggling with Access 2007, trying to teach myself how to build an
expression in a table. My table is a listing of customers, names, address,
the last field I want to put in is "Preferred_Customer", I want this to look
at the "YTD_Orders" and see if it is >= 10000, if so then Yes if not No.
Click to expand...

Storing derived data such as this in your table accomplishes
three things: it wastes disk space; it wastes time (almost
any calculation will be MUCH faster than a disk fetch); and
most importantly, it risks data corruption. If one of the
underlying fields is subsequently edited, you will have data
in your table WHICH IS WRONG, and no automatic way to detect
that fact. For instance, you could have a customer with 9950 YTD
orders; if they order 200 more, their status should change.... but
if the table is already populated it won't.

Just use a *QUERY* based on the table, to count or sum values in YTD_Orders,
and dynamically assign the value accordingly:

IIF(YTD_Orders >= 10000, "Preferred Customer", Null")
 
â€â€ÙƒØªØ¨ "RChamp1969 said:
I am struggling with Access 2007, trying to teach myself how to build an
expression in a table. My table is a listing of customers, names,
address,
the last field I want to put in is "Preferred_Customer", I want this to
look
at the "YTD_Orders" and see if it is >= 10000, if so then Yes if not No.
Click to expand...
 
Back
Top