Re: Searching with one form field

Nick, Thanks a bunch. I figured there was a technique like this, but I just couldn't find it. As it turned out, I figured another route to the same thing. Who is it who's famed for saying, "On the other hand, you could try..."? Dave? I simply added: OR lcase(FN + ' ' + LN) LIKE

Re: Searching with one form field

Hi John, You can split out the words from the entry field using lists, for example: Nick At 14:02 15/05/00 -0500, you wrote: >I have a field, (Person), in a form which will search according to the >following criteria: > >WHERE > lcase(FN) LIKE '%#l

Searching with one form field

I have a field, (Person), in a form which will search according to the following criteria: WHERE lcase(FN) LIKE '%#lcase(Person)#%' OR lcase(LN) LIKE '%#lcase(Person)#%' OR lcase(Real_Name) LIKE '%#lcase(Person)#%' I don't have the first and last names combine