When doing a pass through query SQL characters must be used. So, is there an equivalent to an ampersand? The following query works in within Access databases, but if you put the same query in an SQL database the ampersand character is not recognized.


SELECT OrderID & BundleName As OrderBundle
FROM dbo.OrderBundle
WHERE LineNumber <1000
GROUP BY OrderID, BundleName
ORDER BY OrderID, BundleName

Thanks for any help you can give me.

Coby.

Access uses ANSI SQL 89 while SQL Server uses ANSI SQL 92. Try either putting the SQL string in a string variable, or do this:

SELECT ([OrderID] & [BundleName]) As OrderBundle
...

ANSI 92 should support the older syntax.

Did that work?



mmcdonal