Syntax Help Please (1 Viewer)

[wizcow]

I have made a query that does what I want.
I have coppied it from the SQL window.

SELECT *, [CustomerLast] & ", " & [Title] & " " & [CustomerFirst] AS SoldToCustomer
FROM Customers;

When I insert it into my code it doesn't work.
I think I am haveing some trouble with the " and the ,

Dim strRecordSource As String
    
    strRecordSource = "SELECT *, [CustomerLast] & ", " & [Title] & " " & [CustomerFirst] AS SoldToCustomer" & _
                      "  FROM Customers;"

What do I have to change here?

Thanks
Tom

 

[o1110010]

Did you set a record source too? You probably have to be more specific. VBA doesn't know where [CustomerLast] etc are coming from. try something along the lines of [TableName]![CustomerLast]. Understand?

What is the point of this VBA code? If a query already does it, why do it in VBA too?

 

[pbaldy]

I think the "inner" double quotes around the comma and space need to be single quotes.

 

[Mile-O]

"SELECT *, [CustomerLast] & "", "" & [Title] & "" "" & [CustomerFirst] AS SoldToCustomer
FROM Customers;"

 

[wizcow]

Thanks everyone.

Tom