Re: Sort table, not with SQL!

Lets back up a bit...

>>From original post:
> We have an Access application that is created by an outside vendor. The
one form states: "Please make sure all records in table are sorted by
date..."

Please note the part about an OUTSIDE VENDOR, also the message about
the TABLE. This is part of an data append procedure.

from my second post
> I do not have control over the original code, and we do receive updates
occasionaly.

Rather than this turning into some kind of flame war, we need to look
at the requirements.

It would appear that the OUTSIDE VENDOR is not employing a query to
sort the table before they append. This app is very involved and uses a
large number of procedures and classes. As they will continue to update
this, I do not want to get into rewritting tons of code. I need a quick
and dirty way to make sure the TABLE is sorted.

Unless you can help by showing me some code to SORT THE TABLE, please
don't respond.

I do greatly appreciate the time that has been used in responding to my
request, but the blindspot on using a query is a roadblock at this
point.


-Daron

.

Loading