I am using access 2007 to construct an SQL query, but I need to do this in code. I have several strings (each <= 255 bytes that I attempted to concatenate as below:
Set qdf = dbs.CreateQueryDef("qryTest", str1 & str2 & str3 &str4)
apparently that doesn't work. Does anyone know how to write an Access 2007 query where the query is longer than 255 bytes..