
October 28th, 2001, 01:59 AM
|
|
Junior Member
|
|
Join Date: Oct 2001
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
SELECT TblBusinessInformation.FldComments, TblBusinessInformation.FldBusinessId,
TblBusinessInformation.FldCompanyName, TblBusinessInformation.FldBusinessAddress1,
TblBusinessInformation.FldBusinessAddress2, TblBusinessInformation.FldBusinessCity,
TblBusinessInformation.FldBusinessState, TblBusinessInformation.FldBusinessZipCode
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'.
|