Forum Discussion

Bobaubry's avatar
Bobaubry
Copper Contributor
Jun 07, 2024

Access to Sql Server Migration

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

Resources