Event 1 Office Connector Web HelpOnline Help

Query Wizard - Additional Options
Contents Index

This step is optional and allows you to specify additional options for the query or import.

Name

Enter a name for your query here.  This name will also be used for the named range that holds the query results in Excel.  Excel will modify the name if it is a duplicate or contains illegal characters.  This feature applies to queries only.

Include field names

If this box is checked, then field names will be displayed above the query data.

Adjust column widths

If this box is checked, then the query will automatically adjust column widths to display all data.

Exclude Duplicate Rows

If this box is checked, then rows are only returned for distinct combinations of values in the selected fields.

Move existing columns to make room for the query

Check this box to make Excel shift existing columns to the right as needed to make room for the query. If this box is not checked, then the query will overwrite any data in its way.

Cancel

Click <Cancel> to dismiss the dialog without inserting the query.

Back

Click <Back> to go back to the Conditions screen.

Next

<Next> is disabled because this is the last screen on the wizard.

Finish

Click <Finish> to insert the query.

Help

Click <Help> to display the web help for the associated screen.

See Also



Content updated 12/2/2008
Copyright © 2008 Event 1 Software, Inc.  This documentation may not be copied in full or in part without written permission from Event 1 Software, Inc.