Calculation Field - This should be easy to answer!

[pdbe]

This should be easy but I'm not sure of the function to use:

I want to define a calculation field to return one value if there exists one or more records with a specified string of text in a specified field value, and another value if no records have that specified string in that field.

For example:

" There are no records with 'John Smith' in the field 'Customer Name' "

or:

" There are one or more records with 'John Smith' in the field 'Customer Name' "

i.e. something like this calculation but to search the field 'CustomerName' of EVERY record:

If(CustomerName="John Smith", There are..., There are no...)

Edited July 28, 2005 by Guest

[aaa]

Try to use selfrelation on your "Customer Name" field and Count() function.

Look attachment.

SelfRel.zip