Display Field which contain only the special characters 1

[nishi1982]

Hello,
I'm writing a report with several fields such as ID#, Phone No#, Last Name, First Name etc. I want the report to only display the records which have special characters such as
( ' ) or ( - ) etc. in the Last Name or the First Name fields.
Can somebody guide me to the correct way to get the required output?
Thanks

 

[TheBlondOne]

you could put a formula in the suppress part of the section expert which is like this

instr({Field},"'") = 0 or
instr({field},"-") = 0

HTH

-Steve


"if at first you don't succeed, sky diving is not for you"!!! )

 

[nishi1982]

Thank You...Appreciate your help.