is there a 'contains' command for criteria of queries 1

[AccipiterQ]

I have a list of donors, say a few have donated in more than one event, but I don't want multiple listings of them in my datatables. I have a field that indicates which events they've donated to, let's say it's called 'Donated To'. Let's pretend John Smith has donated to the Turkey Drive and Homeless Shelther. So his entry under 'Donated To' would be "Turkey Drive, Homeless Shelter"


Now I want a query that only returns those who have donated to the turkey drive. So for the "Donated To' field in design view I can't set the criteria to '=Turkey Drive' because that will return only those who have only 'Turkey Drive' in the 'Donated To' field, and not those who haev 'Turkey Drive' along with other things.

So what I'm asking, is there a command that would look at the 'Donated To' field and see if the term I want is contained in it, even if it's not the only thing in the field??

 

[r937]

select ...
from ...
where DonatedTo like '*TurkeyDrive*'

r937.com | rudy.ca

 

[AccipiterQ]

I tried that, I get a syntax error

 

[AccipiterQ]

nm I'm an idiot...I had a mispelling thanks