[AccessD] SQL concatenation

William Hindman wdhindman at dejpolsystems.com
Mon Feb 2 09:47:33 CST 2009


Group

...this works fine

lstFound.RowSource = "SELECT DISTINCTROW tblOrg.OrgID, tblOrg.OrgName, 
tblOrg.Address, tblOrg.City, tblOrg.StateOrProvince, tblOrg.Country, 
tblOrg.Buyer, tblOrg.Inactive FROM tblOrg WHERE (((tblOrg.OrgName) Like 
[txtSearchExpression]) And ((tblOrg.Buyer) = True) And ((tblOrg.Inactive) = 
False)) ORDER BY tblOrg.OrgName;"

...but when I try to concatenate 3 of the fields, I get a syntax error

lstFound.RowSource = "SELECT DISTINCTROW tblOrg.OrgID, tblOrg.OrgName, 
tblOrg.Address, [tblOrg]![City] & ", " & [tblOrg]![StateOrProvince] & " " & 
[tblOrg]![Country]) AS CSC, tblOrg.Buyer, tblOrg.Inactive FROM tblOrg WHERE 
(((tblOrg.OrgName) Like [txtSearchExpression]) And ((tblOrg.Buyer) = True) 
AND ((tblOrg.Inactive) = False)) ORDER BY tblOrg.OrgName;"

...any help appreciated.

William
 





More information about the AccessD mailing list