Yes you can create strings to hold SQL statements but what do you want to do with them? Also, it is much more efficient to use stored querydefs than embedded SQL strings. You should only create SQL strings in VBA if the query can be structurally different each time it runs.