Searching a string field 1

[TheBlondOne]

Hi all,
I am designing a report for different schools e.g(Catholic, Church of England etc..)to go to different addresses when run, my problem is this. I need to search through the school name to see whether or not it contains the letters CE(C) and then display a 1 infront of the school name if it does so that i can use this as an identifier to select the relevant address. I have tried using a for loop to search the string, but to no avail (i am probably doing something wrong). Hope that makes sense. Can someone help me please.

Thanks in advance

 

[BFAGG]

Try a formula:

If {Fieldname} like '%STRING% then 1 else 0.

This will return the control value to select the addresss.

You then need to put each of the various addresses into a separate detail section. You then suppress the section depending on the control value.

Hope this helps.

Bill

 

[TheBlondOne]

Cheers Bill thats done the trick, i think i was trying to do things too complicated. Thanks a lot