T
tim johnson
How can I format this SQL string taken form the SQL view
of a query so I van use it in a procedure.
I am having problems with the double quotes.
SELECT tblCustomer.CustomerID, [LastName] & ", " &
[FirstName] & " " & [MI] AS Customer, tblCustomer.Street,
tblCustomer.City, tblCustomer.State, tblCustomer.Zip
FROM tblCustomer
ORDER BY [LastName] & ", " & [FirstName] & " " & [MI];
Thanks
of a query so I van use it in a procedure.
I am having problems with the double quotes.
SELECT tblCustomer.CustomerID, [LastName] & ", " &
[FirstName] & " " & [MI] AS Customer, tblCustomer.Street,
tblCustomer.City, tblCustomer.State, tblCustomer.Zip
FROM tblCustomer
ORDER BY [LastName] & ", " & [FirstName] & " " & [MI];
Thanks