Query view

The query you are designing is shown in the query area.

Renaming rule for table name

When your data source is MDB or MS-SQL, if a table name includes blank or number, the table name is renamed in your SQL statement.

•Table name includes blank  ex) Car Sales -> [Car Sales].fieldname

•Table name begins with a number ex) 1Sales -> [1Sales].fieldname

•Table name is the same as field name ex) Sales.Sales -> [Sales].Sales