Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return a figure if field contains certain data 1

Status
Not open for further replies.

rewob65

Technical User
Nov 13, 2004
110
GB
I am trying to wrie a formula for if data contains "H".

This means the H could be anywhere in the string or even not be presnet ie

ACHBN
AFB
AHDNB
HTV

I would want to return line 1 3 and 4

Thanks
 
Hi,
What have you tried?

InStr({datafield},'H') > 0

in your record selection formula for instance?



[profile]

To Paraphrase:"The Help you get is proportional to the Help you give.."
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top