2 Replies Latest reply on Mar 5, 2010 7:38 AM by paintboothguy

    Omit records with a blank field....

    paintboothguy

      Title

      Omit records with a blank field....

      Post

      Good Morning, 

       

      I would like to 'find' all records with a certain value in one field, but not have them be included if another field is blank.

       

      Or to put it another way:

       

      I would like to find all records that have the value 'B.S.B.' in a certain field, but if a record doesn't have an email address, I don't want it included in the found set.

       

      Can anyone help?

       

      Thanks, 

      Andrew