AnsweredAssumed Answered

Find with OR and AND

Question asked by sburech on Jan 19, 2011
Latest reply on Jan 19, 2011 by philmodjunk

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.

Outcomes