MSAccess Query

[camster39]

Have a field called "Store Name". Want to create a simple If-then statement that if the value of store name contains "Mike's" then display a "Y" otherwise display an "N".

I tried doing something like:

Answer: IIf([STORE].[NAME]="Mike's","Y","N")

Then I realized that the store name contains the word "Mike's" but that isn't the entire value (i.e. Mike's Furniture, Mike's Hardware, Mike's House).

So I guess I'm looking for an IIf but instead of returning a "condition true" for an exact match I would want to return a "condition true" for a partial match.

Using Access 97.

Thank you.

 

[SkipVought]

Hi,

 IIf([STORE].[NAME] Like "*Mike's*","Y","N")

Skip,

_{[red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it!}