Selecting multiple columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using shift key I can select continuous columns. But what about
non-continuous ones? I tried using Ctrl but of no avail. For sorting, the
help text says "select in the order of sort needed" but nowhere it says how
to do it. Right now, I don't want to use the query format. Thanks
 
The best way to do this is to use a query.

I do not know of a way to do what you are asking. You can drag the columns
of the table into a new order while in datasheet view (click on header and
drag to new position). When you drag the columns you want to sort on
together, you can then select them all and sort by the groups. As you have
found the columns will have to be adjacent to each other.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Realistically, you should be using queries: they're a critical part of
relational databases.

Actually, it sounds from this and other questions you've had that you're
working directly with the tables. You should have forms, and use them as the
interface for updating your data (just as you should have reports to display
your data). In that way, you can put validation rules in the form's
BeforeUpdate and/or BeforeInsert event.
 
Back
Top