Specify which fields, sums and counts to include in your SQL query. Several caveats apply for various query types.
Query Type |
Action |
Table controls |
Since all fields are automatically selected for table controls, the SELECT step is disabled for editing. |
Filter control |
Only one field may be selected since Filter controls display only one field. Only columns with filterable data types are selectable for filters. |
FieldValue control |
Only one field may be selected since FieldValue controls display only one field. |
Sums and counts |
Calculations are supported only for numeric columns. When working with data sources, calculations are available for the from table, to table, and all join tables |
DropdownList |
Only one field may be selected |
ListBox |
Only one field may be selected |
At present, data sources cannot contain calculations from more than one table.
Customizing Database Queries with the Query Wizard
The Query Wizard ORDER BY Step