sql server programming: Hello,
I had an access application and have moved my tables into SQL Server. I had
an access query that ran fine but no longer does. I am getting an invalid
operation error. Can someone help me with why this no longer works. Several
of my queries are not working. I am wondering if there is some sort of
resources for changes that I need to make to my queries when converting from
Access to SQL Server.

Thanks,


SELECT All2006To2007.CustomerName, All2006To2007.[2007_Sales],
[2004YTD_TrxSummary].[2004_Sales], All2006To2007.SalesRep, All2006To2007.State
FROM 2004YTD_TrxSummary INNER JOIN All2006To2007 ON
[2004YTD_TrxSummary].customerref_ListID = All2006To2007.customerref_ListID;

--

Can you provide the entire query and the exact error message.

I have done a few Access to SQL migrations and in the end you simply have to
convert the Access queries because there are functions and syntax that do
not work in SQL, but I don't see anything in the excerpt you provided.

Michael MacGregor
Database Architect