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

Omit records with a blank field....

paintboothguy Mar 5, 2010 7:27 AM

Title

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

1. Re: Omit records with a blank field....

LaRetta_1 Mar 5, 2010 7:36 AM (in response to paintboothguy)

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

Enter Find Mode [ uncheck pause ]
Set Field [ yourField ; "B.S.B." ]
Set Field [ email ; "*" ]
Set Error Capture [ On ]
Perform Find
.. trap for errors

This will find all records with B.S.B. AND has an email address. Does this give you what you want? :smileyhappy:
Like Show 0 Likes(0)

Actions
2. Re: Omit records with a blank field....

paintboothguy Mar 5, 2010 7:38 AM (in response to paintboothguy)

Thanks, LaRetta!
Like Show 0 Likes(0)

Actions

Go to original post