1 Reply Latest reply on Jan 19, 2011 8:10 AM by philmodjunk

    Find with OR and AND

    sburech

      Title

      Find with OR and AND

      Post

      I have a layout with a drop down menu with check boxes besides the years 2010, 2011, 2012. I want to find any records that are missing a street address OR a telephone number OR an email address for the year 2011.  I proceeded to click the find command; put an = into the street address field; in the menu I selected Requests->Add New Request; put an = into the telephone field;in the menu I again selected Requests->Add New Request; put an = into the email address field; put a x into the year 2011 box and then pushed find.  I received records with missing telephone numbers, street address OR emails for BOTH 2010 and 2011.  How do I confine my search to those missing items only for 2011.  I am using FM-11 on a MAC PowerBook G-4.