Sorting in Datasheet View

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

Guest

Hi all,

Alright, this is a really stupid question, but I can't figure out how do to
undo what I've done.

I'm parsing a text file and adding each item to the table, one at a time.
One time I viewed the data in the table and I sorted it by one field. Then I
saved the design and thought nothing of it. Now, when I go back, it's always
sorted by that one field. I tried removing data sort/filter option, and it
does nothing. I tried recreating the table and it still sorted the data
according to the field. The data (I believe) should be in the DB as it was
entered. First record in the file should be first record in the table, and
so on.

Anyone know how to reset the datasheet view? I'm all lost.

Thanks,
Jay
 
Open the table in design view
Press Alt+Enter to get the properties of the table
Check the order by properties, and delete the field name
Save the table
Open again
 
There was an entry in the Order By property, but it still sorts according to
that table after I deleted the entry (and saved).

Thanks for the idea though, didn't know about that one.

Jay
 
If the field it sort by is the key, then its a normal behaviour of the table,
unless you specify other wise
 
Jay,
I think the problem your describing is... you now have no field on which
to "sort back" to the "original" sequence. Sounds like you have no Index
field, or DateOfCreation date to put them back teh way they were...

The sequence should not be a critical issue... your data's all there...
Why are you concerned that they are not in the original sequence? How
the table is sorted can be changed "on the fly" for any Form, Query, or
Report.
Without seeing all your fields, and some sample data, I'm assuming you
may be out of luck.

If maintaining the original sequence was critical, you should have
created a key
Index field (like an autonumber) that gives each added record a sequentially
increasing number.
Or... added a DOC (DateOfCreation) Date field to your table, that places
the Date and Time in a field every time you create a new record.
That way the records could always be put back in just the sequence they
were entered.
 
Back
Top