Sort limit in Access

  • Thread starter Thread starter Ernest Stokely
  • Start date Start date
E

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).
 
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
 
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).
Click to expand...

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).
Click to expand...

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.
 
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
________________________
 
Back
Top