Table in database will not sort

L

Len

I have one table in a database that will not sort. I am also unable to
compact the database and I feel this table is the problem. Any suggestions?
 
T

Tom

First thing to try would be "Compact & Repair"
If that doesn't help I would start a blank database and copy all objects
from the original.

What type of field does not want to sort?
 
R

Rick Gittins

Look at the properties of the table and see if a sort order has been saved.
If it has then remove it. If this isn't the problem what is the data type
of the field you are trying to sort? A Memo data type you can not sort and
if you have text data type and have numbers enter into the field it will
sort your numbers differently.

Let me know if this doesn't answer you question.

Rick
 
Top