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, ...