AndyClay
03-03-2005, 09:28 AM
I am using Query Design to set up a new query.
I have one field that contains a surname. I need a formula that returns TRUE (or a value) when the surname contains "DECEASED" and FALSE (or an error) when the surname doesn't.
The Worksheet function SEARCH doesn't seem to work. Any ideas?
I have one field that contains a surname. I need a formula that returns TRUE (or a value) when the surname contains "DECEASED" and FALSE (or an error) when the surname doesn't.
The Worksheet function SEARCH doesn't seem to work. Any ideas?