Sorting Records in a Table

[JBuckley2000]

Hey,

I was wondering if it was possible to save my records after I perform my sort so every time I open the table, they are in the order I want them to be in? Access help says no, can anyone shine some light on this for me? JSF

Jason Facey
jfacey@lithonia.com

 

[PaulF]

not sure what you're trouble is. I just opened a table in datasheet view, sorted and saved it, and when I opened it again it was in the order I had just saved. If you are now using datasheet view, then there's no reason to worry about sorting the table, because you can just create a Select query to sort it in the way you want it, and then open the query when necessary.

PaulF

 

[JBuckley2000]

Well my Access 2.0 is not doing such a thing...I save it, open it back up and it is how it was originally. This is just what the user wants so they can see how records were entered. I am saving the table and Access 2.0 help says when u close a table, you will lose all sorting you added. This stinks. JSF

Jason Facey
jfacey@lithonia.com

 

[PaulF]

my previous message should have stated "not using datasheet" instead of "now using datasheet'. As far as using Access 2.0, I don't have any experience with it. My example was in 97. Can't you just use a query?

PaulF

 

[MTGMAN64]

I'm not sure where you got that information but you can most definitely sort your records within a table and then save it. The next time you open the table your records will still be in the same sort order as you specified. Just bring up the table in table view and click the field you want to sort by. Click either the ascending AZ or descending ZA icon on the toolbar, then click the Save icon and you're done. The limitation in a table is that you can only sort by one field. If you want multiple sort orders you'll have to do that in a query. Design a make table query that includes all of the fields from the table. Designate you sort order in a left-to-right fashion in order of precedence.