Sorting tables

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

Guest

When I import excel files that have both text and numbers into Access Tables,
Access seems to automatically sort by number. I know building a query on the
table would allow sorting but I can't use queries in what I'm doing. I have
to go directly to a form. I've tried the OrderBy property in the table and
the OrderByOn event in the form but to no avail. I've also tried changing
the number fields to text fields as the numbers are not for calculation.
Ideas will be appreciated.
 
Solved. When I make tables out of other tables, I have to use queries to
bring the fields from each table and so, was able to sort ascending on the
name and put no sort on the number fields.
 
Back
Top