in access go to queries then select new query, after that a screen is brought up that allows you to choose fields you can close that and click the sql button in the left corner this will allow you to type in you sql query directly