When using SQL statements in Microsoft access, you can generally use any SQL syntax. However, there are a few exceptions:
- You can't use the DISTINCT clause within an aggregate function
- You can't use the LIMIT TO xx ROWS clause
- The single character wildcard in Access is ? rather than _.
- The zero or more character wildcard in Access is * rather than %
- Start Microsoft Access 2007.
- Open the database containing the query you wish to view or edit.
- Locate the query in Object Explorer and double-click on it to run the query.
- Pull down the View menu in the upper left corner of the ribbon.
- Select SQL view. This will display the SQL statement corresponding to the query.
- Make any edits you wish to the SQL statement in the query tab.
- Click the Save icon to save your work.