How to create SQL query against Access database?
Simple question from a n00b here. I’ve connected the Access application to a local copy of a database and can see the tables; now I need to make an SQL query against one of the tables.
When I click on “View” in the ribbon, there’s two choices: Datasheet View and Design View.
I’m expecting a third choice, SQL View, but I don’t see that option.
Simple question from a n00b here. I’ve connected the Access application to a local copy of a database and can see the tables; now I need to make an SQL query against one of the tables. When I click on “View” in the ribbon, there’s two choices: Datasheet View and Design View. I’m expecting a third choice, SQL View, but I don’t see that option. Am I looking in the wrong place for SQL queries? Read More