You cannot even supply the correct table?
Code:
SELECT Left([SimilarArtistsID],1) AS Expr1, ArtistsID_Similar_Artists_tbl.SimilarArtistsID
FROM ArtistsID_Similar_Artists_tbl;
Your code
Code:
SELECT Artists_Names_Similar_Artists_tbl.ASA_ID AS Expr1, Artists_Names_Similar_Artists_tbl.DUP AS Expr2, Artists_Names_Similar_Artists_tbl.DyEvn AS Expr3, Left([Artists_Names],1) AS FirstLetter, Artists_Names_Similar_Artists_tbl.Artist_Names AS Expr4, Artists_Names_Similar_Artists_tbl.[SAID/DUP] AS Expr5, Artists_Names_Similar_Artists_tbl.SimilarArtistsID AS Expr6, Artists_Names_Similar_Artists_tbl.[DUP (S/A)] AS Expr7, Artists_Names_Similar_Artists_tbl.[S/A\ArtistID] AS Expr8, Artists_Names_Similar_Artists_tbl.[#S/AID] AS Expr9
FROM Artists_Names_Similar_Artists_tbl;