Sort limit in Access

[Ernest Stokely]

I am encountering a strange problem with a straightforward Access sort
in a query. It sorts the first 249 records in ascending order, then
starts all over again for the remainder of the records (about 25
more). I have tried this on a couple of fields in the table, and it
does the same thing (meaning there is nothing peculiar about the data
in the field that is causing the problem). I cannot find anything that
says there should be a limit on the number of records that a query
will sort up to the limit of the database size (1 GB).

?? Any suggestions, anyone?

Pls also send reply to (e-mail address removed).

 

[Liz]

What's your field data type for each field that is giving
the problem?

 

[Michel Walsh]

Hi,


Sorting strings that look like numbers create what look like "strange" sort.
Since "az" comes before "b", "19" comes before "2", so you may get:


1
10
11
12
2
3
4
....

if the column is a string, in reality. The sort is right, in that case.


Hoping it may help,
Vanderghast, Access MVP

 

[John Vinson]

I am encountering a strange problem with a straightforward Access sort
in a query. It sorts the first 249 records in ascending order, then
starts all over again for the remainder of the records (about 25
more). I have tried this on a couple of fields in the table, and it
does the same thing (meaning there is nothing peculiar about the data
in the field that is causing the problem). I cannot find anything that
says there should be a limit on the number of records that a query
will sort up to the limit of the database size (1 GB).

Please post the SQL view of the Query. This is NOT typical behavior!
There is no limit to the number of records that can be sorted (short
of as you say, the size of the table).

?? Any suggestions, anyone?

Pls also send reply to (e-mail address removed).

Done... but a couple of warnings. Most of us who answer questions
here are in business as developers on a contract basis, or as
employees of a business; for my part (and for most), private EMail
support is reserved for paying clients. Requesting EMail is considered
impolite; if it's worth my time to log on and answer questions, it
should be worth yours to come back to the newsgroup for the answer!
Please respond to the newsgroup, not by private EMail (unless, of
course, you'ld like a copy of my consulting terms).

Also, there are a lot of spammers and viruses out there which harvest
EMail addresses from the newsgroups; most of us use fake addresses for
this reason. When (not if, alas!) you get an EMail message purporting
to be a security upgrade from Microsoft, be aware that it's not; it's
a copy of the SWEN virus which will infect *your* computer and start
sending out more copies of itself if you open it.

 

[Gary Miller]

Something else that could be going on. There wouldn't be a "
" blank space at the beginning of the data for the first 249
records, is there?

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________