Sorting tables

H

Hughie

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.
 
H

Hughie

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot sort a table containing text 5
How to have two tables on same line? 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2010 DB not fuctional with multiple users 2
Combo or list box 0
Sort in VB using a ComboBox Column Other than the Bound Column 4
How do I clear a form? 0
Using Styles In An Outline 0

Top