Jeff said:
That does not answer my question -
are you telling me that there is no way to sort it?
The very definition of modern database and information management systems is
that if you need some particular order, you must specify that order.
It is likely that you are new to the concepts of computing and computing
science and the computer industry in general, so you're new to this stuff,
and that's not really a problem.
Just read on a little bit more and I explain much why systems work the way
they do:
The solution is as mentioned is to use a query and YOU must set the order of
data. You MUST have some means of setting the order. Remember in a multi
user environment someone might edit data that will change the order in which
you need the data. If you have ten people from 10 different locations from
around the world and they ALL start entering data into the SAME table, then
the last ten records you just entered are from ten different people from ten
different countries around the world. You can rapidly see it becomes a pink
cloud fantasy to ensure order of data in a physical sense. At this point in
time, how would order of data entry matter in any way shape or form, because
of multiple people entering records together from multiple sources , you
simply have a mumbo jumbo of records intermixed. because the new modern
database in jeans are multi user, then the industry as a general hold
decided that the only way to ensure order of data is for the designers of
the application software to specify some order of data. And
THAT means given to you is a query!
In fact for more than fifteen years MS access NEVER guarantees the order of
data in which you enter the data. That means if you enter ten records into a
table, and go back and edit the fifth to record, it might jump to the
seventh position in the table. you can certainly set a sort order on a table
in access any usually remembers it, but when it comes down to making a
report, then you must use the sorting and grouping options of that report to
set the order.
In the case of exporting data to a csv/text file, you simply MUST use a
query, and MUST set the order in that query to order the data in the order
that you desire to have for the export. If your original table does not have
some means of ordering the data, then you cannot in any fashion be sure that
order will be maintained during an export.
again:
a database is considered an unordered collection of data. YOU MUST set the
order of data by using a query that orders your data in a fashion that you
require your data. There's simply no other solution and no other approach in
the modern computing industry that works any other way.
This is a major flaw in Access.
And Sql server, and MySql, and Oracle, and Informix, .and d3....and
virtually every major single database product in the marketplace works this
way
I'm really not sure why or what the problem is preventing you from exporting
this data via a query?
Also another flaw is that the decimal place
is truncated unless you specify "formatt" in the query but that is another
issue.
in general the approach is to simply use the format command and you can
format the export data as you desire...
