RE: Pulling results from 1 Text field and 2 Select Lists

Joe, That was just the ticket!  Thanks!! It is by design that they are limited to 4. Thanks again.   _   From: Joe Rinehart [mailto:[EMAIL PROTECTED] Sent: Saturday, August 07, 2004 3:07 PM To: CF-Talk Subject: Re: Pulling results from 1 Text field and 2 Select Lists Hey Steve, At

Re: Pulling results from 1 Text field and 2 Select Lists

Hey Steve, At first glance, you need to partition off the seperate conditional queries in your clause. This should help: SELECT * FROM tblLawyers WHERE 0=0  AND LName LIKE '%#FORM.LName#%'  AND ( County1 LIKE '%#FORM.County#%' OR County2 LIKE '%#FORM.County#%'