Microsoft Office Tutorials and References
In Depth Information
Selecting individual columns from one or more tables
Selecting individual columns from one or more tables
Selecting individual columns has the advantage of enabling you
to see exactly what is being selected. It also simplifies
filtering and sorting because you can apply the criteria and sorting
against the selected columns.
(because you cannot sort against the *), but clear the check
marks in the row titled Show when adding the column because
you are already showing the column as part of the *, which
selects all columns.
If you use the * to include all columns in a table and need to sort
by a column, you must add the column for sorting to the query
1
Select individual columns
1 In design view, double-click a column to add it to the grid (or drag
it into the grid).
CAUTION Don’t include the same field more than once.
Otherwise, you are creating additional overhead. This can also
create problems when you start to build forms and reports based on
the query. The query automatically gives a new name to duplicated
fields because each field name in a table or query must be unique.
TIP To delete columns, click just above the column name on
the column header and press Delete. You can insert columns by
pressing the Insert key after you select a column header. The ribbon
also has buttons to support these operations.
Search JabSto ::




Custom Search