Query multi select help please

[Paul Milner]

Hi
I have a form with some check boxes with the same name
which direct there output to the same field
(Sponsorship_type), in an access database.The resulting
field value reads something like:
(Events,Appeals,campagn) depending on the search.

The SQL is
fp_sQry="SELECT * FROM Results WHERE (Sponsorship_type
= '::Sponsorship_type::') ORDER BY Project_ID ASC"

When I search for lets say Events it wont display the
record set unless I enter all of the entries in the
record ie (Events,Appeals,campagn )
How can I change the search criteria so it will return
the record set even if I search on one of the record
enties, say Appeals
Thankyou
Paul M

 

[Jim Buyens]

Howdy. Try:

SELECT * FROM Results
WHERE (Sponsorship_type LIKE '%::Sponsorship_type::%')
ORDER BY Project_ID ASC

However, keep in mind that seaching for "aim" will hit on
(claims,motion) as well as (ready,aim)

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

 

[Guest]

Thanks works a treat
I am realy a talented Brain surgeon But new to this