Omit records with a blank field....
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
" 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:
Thanks, LaRetta!
" 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: