66 99

[kingz2000]

Hi,

I am dynamically changing my Query using VBA Code, and I came accross a problem, which I hope you can help out on:

my SQL need to read:
select Apples & "/" & Pears as Fruits from Table

NOw in my code I have

dim StrSQL as string
strSQL = "select Apples & "/" & Pears as Fruits from Table"

Naturally, the speech marks get in each others way.How do I get around this???

 

[SkipVought]

Hi,

strSQL = "select Apples" & "/" & "Pears as Fruits from Table"

Skip,

_[red][/red]

 

[mp9]

Hmm. Try

strSQL = "select Apples & ""/"" & Pears as Fruits from Table"

Or

strSQL = "select Apples & '/' & Pears as Fruits from Table"

http://www22.brinkster.com/accessory/

 

[SkipVought]

strSQL = "select Apples &'/'& Pears as Fruits from Table"

Skip,

_[red][/red]

 

[JerryKlmns]

Dim myExactFieldName As String

myExactFieldName = "Apples &" & Chr(34) & " / " & Chr(34) & "Pears"
strSQL = "SELECT [" & myExactFieldName  & "] As Fruits FROM Table"

Nice name you 've got there! Do you think you should change it ?