I'm in the unfortunate position of having to run a SQL query through Access. What I'm trying to accomplish is to search for records that contain keywords within a text field. This is the query I have written:
FROM TblBusinessInformation
WHERE (((TblBusinessInformation.FldComments) Like "FEMA" & "SBA" Or
(TblBusinessInformation.FldComments) Is Null));
The bold text is where is see a possible problem. 1) I'm not sure about the double quotes, I've always used single quotes. Not sure if it matters or not, but I would assume it does. 2) The "like" argument is saying the entire field should be "fema" or whatever, not just a certain part of it. You want a different argument there, off the top of my head, I can't recall it. "IN" maybe??? Sorry bout the ramblin'.