Can't figure out a an IF statement.

[mackgee]

I have a test field that is as follows:

Work Order 00041580.1.1.2 #3: Part demand for 1 411-01001-004 issued.
Work Order 00041580.1.1.2 #3: 1 411-01001-004 requested on Part/Service Request RQ05-00849.
Work Order 00041580.1.1.2 #4: Part demand for 1 411-01002-020 issued.
Work Order 00041580.1.1.2 #4: 1 411-01002-020 requested on Part/Service Request RQ05-00850.

What I am trying to do is make a count of my part demands and my part requests. So I'm trying to put together an IF statement that will perform the following functions:

Count for the demands:
IF([TEXT FIELD] CONTAINS "*Part demand for*",1,0)

Count for the requests:
IF([TEXT FIELD] CONTAINS "*requested on*",1,0)

However, I so not know what to use for the CONTAINS. I tried:
IF([TEXT FIELD]="*requested on*",1,0)

This did not work. If anyone knows of a way to create an IF statement for a text field with wildcards then help would be appreciated.

 

[mackgee]

Nevermind I just figured it out.

 

[lespaul]

why would you keep all that information in a single field?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[PHV]

Have a look to:
IIf
Like

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886