Why do I keep getting an error code when I'm trying to run the query?

Question

syntax error in query expression
SELECT [Name] FROM MSysObjects WHERE [Type]=5 And Left([Name],1)<>”~” ORDER BY [Name];

Answer 1

Your double quote char is invalid. Not sure what character you are using, but you can use double quotes

SELECT [Name] 
FROM MSysObjects 
WHERE [Type]=5 AND LEFT([Name],1)<>"~" 
ORDER BY [Name]; 

or apostrophes

SELECT [Name] 
    FROM MSysObjects 
    WHERE [Type]=5 AND LEFT([Name],1)<>'~' 
    ORDER BY [Name];