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.