dynamictiger
Registered User.
- Local time
- Today, 13:56
- Joined
- Feb 3, 2002
- Messages
- 270
This is SQL statement I want to manipulate in VBA:
"SELECT [ClientName] & " "& [PoolAddress] AS ClientDetail, " & _
"[FirstName] & " " & [LastName] AS ClientName, [StreetNumber] " & _
" " & [StreetName] & " " & [RoadType] & " "& [Locality] & " " & " & _
"[PCode] AS PoolAddress, tblServJob.JobDate, tblServJob.TimePromised, " & _
"tblServJob.AllocatedTime, tblServPerson.ServicePerson, " & _
"tblServJob.JobDescription " & _ etc
As you can see there are spaces all through it. How do I make this work in VBA?
"SELECT [ClientName] & " "& [PoolAddress] AS ClientDetail, " & _
"[FirstName] & " " & [LastName] AS ClientName, [StreetNumber] " & _
" " & [StreetName] & " " & [RoadType] & " "& [Locality] & " " & " & _
"[PCode] AS PoolAddress, tblServJob.JobDate, tblServJob.TimePromised, " & _
"tblServJob.AllocatedTime, tblServPerson.ServicePerson, " & _
"tblServJob.JobDescription " & _ etc
As you can see there are spaces all through it. How do I make this work in VBA?