I am trying to come up with Access code that will allow a query to migrate to Sql Server. The current Access Sql is:

SELECT Last(tblSecurityPrices.Price) AS LastOfPrice, tblSecurityPrices.Security, Last(tblSecurityPrices.PriceDate) AS LastOfPriceDate
FROM tblSecurityPrices
GROUP BY tblSecurityPrices.Security;

I know very little about Sql Server. Bob

​I am trying to come up with Access code that will allow a query to migrate to Sql Server. The current Access Sql is:SELECT Last(tblSecurityPrices.Price) AS LastOfPrice, tblSecurityPrices.Security, Last(tblSecurityPrices.PriceDate) AS LastOfPriceDateFROM tblSecurityPricesGROUP BY tblSecurityPrices.Security; I know very little about Sql Server. Bob  Read More

​