A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Access 2007 expression in a table



 
 
Thread Tools Display Modes
  #1  
Old April 5th, 2010, 03:36 AM posted to microsoft.public.access.gettingstarted
RChamp1969
external usenet poster
 
Posts: 1
Default Access 2007 expression in a table

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.
  #2  
Old April 5th, 2010, 06:11 AM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default Access 2007 expression in a table

On Sun, 4 Apr 2010 19:36:01 -0700, RChamp1969
wrote:

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.


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")
--

John W. Vinson [MVP]
  #3  
Old April 5th, 2010, 08:05 AM posted to microsoft.public.access.gettingstarted
شوووووق
external usenet poster
 
Posts: 1
Default Access 2007 expression in a table



‏‏كتب "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.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 OfficeFrustration.
The comments are property of their posters.