SQL strings with ” (2000)

Topic

New Reply

I am unable to modify the following statement to include a space between [FirstName] and [LastName]

strSQL = “INSERT INTO tlkpMembersAvailable (MemberID, MemberName) SELECT [MemberID], [FirstName] & [LastName] AS MemberName FROM tblMembers;”

(which is then run by) DoCmd.RunSQL strSQL

It’s not for want of trying, I just can’t figure out where to stick the extra quotes without ruining the syntax of the string.

Reply | Quote

Replies

Hi Darsha, you can use

[FirstName] & ' ' & [LastName] AS MemberName

I used single quotes around the space because you already use double quotes to delimit strSQL. As an alternative, you could use double double quotes

[FirstName] & "" "" & [LastName] AS MemberName

Reply | Quote

That’s it, I think I’d tried everthing but! Thanks for the prompt reply

Reply | Quote

That’s it, I think I’d tried everthing but! Thanks for the prompt reply

Reply | Quote

Hi Darsha, you can use

[FirstName] & ' ' & [LastName] AS MemberName

I used single quotes around the space because you already use double quotes to delimit strSQL. As an alternative, you could use double double quotes

[FirstName] & "" "" & [LastName] AS MemberName

Reply | Quote