Fields Tab, Query and View Designers

Specifies fields, aggregate functions, and other expressions for query or view output. This tab appears in the Query and View Designers.

Available fields: Lists all the fields available in the tables of the query or view. You can select all available tables and their fields by choosing the asterisk (*), all fields in a particular table by choosing table.*, or individual fields for your query or view. Your selections appear in the SELECT statement in the SQL window when you click the SQL button or choose View SQL from the Query menu. If you select a field in the Available Fields list, its name automatically appears in the Functions and expressions edit box and in the Expression edit box of the Expression Builder, which opens when you click the ellipsis (...) button.

Functions and expressions: Specifies a function or expression. You can either type an expression directly into the box or select a function from a list in the Expression Builder, which opens when you click the ellipsis (...) button. After creating your expression, you can add it to the Selected fields box by clicking the Add button.

Selected fields: Lists the selected fields, aggregate functions, and other expressions that appear in the query or view results. You can rearrange the order of the output by dragging the vertical double arrow to the left of the fields.

Add: Adds the selected item from the Available fields box or the Functions and expressions box to the Selected fields box.

Add All: Adds all fields from the Available fields box to the Selected fields box.

Properties: Displays the View Field Properties Dialog Box, which makes it possible for you to specify options for fields in a view just as you do for fields in database tables. This option is available only in the View Designer.

See Also