how to sort a table in code, something like rs.sort = "GroupNumber

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

Guest

how to sort a table in code? rs.sort = "GroupNumber" ??

I did this and it gave no error but it did not sort table?
why might this be I wonder?????
thanx
 
Tables store data. The data is stored in no particular order. These are
not user-interfaces, they are simply a place to store the data.

The user interfaces are the forms and reports (and to some degree queries).
If your order is important, then you need to be woring with a query, form,
or report.

Rick B
 
how to sort a table in code? rs.sort = "GroupNumber" ??

I did this and it gave no error but it did not sort table?
why might this be I wonder?????
thanx
Click to expand...

A table HAS NO ORDER.

It's a "heap" of data. If you want to display data in GroupNumber
order you must - no option! - use either a Query sorting the data by
that field, or a Form or Report specifying the sort order in the Form
or Report's properties.

Tables should not generally even be *seen* by users; table datasheet
view is good for design and debugging, but anytime a user interacts
with data it should be through a Form - where you can specify a sort
order easily.

John W. Vinson[MVP]
 
Back
Top