SQL Editor

Press the 'Query Editor' button on the toolbar or ribbon (Create > Queries) to Start the SQL Editor. The SQL Editor replaces the MS Access built-in SQL editor.

Features:

• Color coding of SQL keywords and functions for improved readability
• Use Templates to do apply common SQL fragments, such as nz({FIELD}) or format(...)
• Find and replace
• Fast insertion of fields (insert Item)
• Syntax problems help: marks unmatched brackets in red (
• Open editor for underlying query by using right click on it in current open editor

Controls:

• Save
• Undo
• Design
• Find
• Replace
• Insert Item
• Open
• Save As

Save

Save current changes.

Undo

Undo editing

Design

Open the query in design mode

Find & Replace

Query Editor Find and Replace (Find & Replace strings or fields in the SQL)

Insert Item

Insert a field

Open

Run the query

Save As

Save changes under a new query name