Share via

Fields Tab, Query and View Designers

  • Article

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

Reference

Filter Tab, Query and View Designers

Group By Tab, Query and View Designers

Order By Tab, Query and View Designers

Update Criteria Tab, View Designer

Join Tab, Query and View Designers