Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Fields Tab, Query and View Designers

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.

Remove

Removes the selected item from the Selected fields box.

Remove All

Removes all items from 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

Community Additions

ADD
Show:
© 2015 Microsoft