Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
SELECT TableName.FieldName, Mid([FieldName],7,255) AS Expr1
FROM FieldName
ORDER BY Mid([FieldName],7,255) DESC;
SELECT Mid([Location],7,255) AS [New Location]
FROM Locationtab
GROUP BY Locationtab.Location, Mid([Location],7,255)
ORDER BY Mid([Location],7,255) DESC;