mega search FAQ

[Naoko_syd]

Hi all,

Thank you so much for your all your tips.
I want to use the mega search in FAQ here:

http://www.tek-tips.com/faqs.cfm?fid=1177

I am wondering if there is any way to search using IF in here:

AddToWhere [Find1], "[CustomerName]", MyCriteria, ArgCount
AddToWhere [Find2], "[City]", MyCriteria, ArgCount

Let's say, if a user wants find what is in [Find2] which may be either in [City] [City2] or [City3], is there a where to do so? One combo box, but search multiple fields...?

Thank you in advance.

Naoko

 

[Andrzejek]

You could write your own search:[tt]
Select [whatever]
From YourTable
Where [City] = [Find2]
Or [City2] = [Find2]
Or [City3] = [Find2][/tt]

Have fun.

---- Andy

There is a great need for a sarcasm font.