Sorting records in a query


I am having a problem sorting records in a query. I have about 5, 000
entries in a table and when I build my query based on certain fields,
the numbers in certain columns are not in order although I use the
sorting feature. ( e.g.) I have 5 columns with numbering data contained
in the columns, and I have it set up to sort in ascending order, which
it did, but I noticed that the Volume # column sorts the Volume numbers
differently (see example below):

V. 1
V. 10
V. 11
V. 12
then it goes back to
V. 2
V. 3
V. 4
V. 5
V. 6
V. 7
V. 8
V. 9

It looks like it sorts anything with a 1 first then the rest later.
How do I fix this?

Thanks.


--
reeve13
------------------------------------------------------------------------
reeve13's Profile: http://www.hightechtalks.com/m120
View this thread: http://www.hightechtalks.com/t2281283

.

Relevant Pages

  • general question about how best to cache expensive query results
    ... The question is that when I have a query like: ... entries to those that are newer than a certain date, ... ascending order in order of creation and find the highest id that's at ... as well as dealing with values having different types. ...
    (comp.databases)
  • Re: Sorting records in a query
    ... > I am having a problem sorting records in a query. ... > entries in a table and when I build my query based on certain fields, ... > in the columns, and I have it set up to sort in ascending order, which ... > It looks like it sorts anything with a 1 first then the rest later. ...
    (microsoft.public.access.queries)
  • Re: general question about how best to cache expensive query results
    ... The last restriction in the query is the one that is too expensive to ... entries to those that are newer than a certain date, ... ascending order in order of creation and find the highest id that's at ... -- or, more like your original, in case ids might not be ordered ...
    (comp.databases)
  • Re: Differences in Range Scan Performance between Binary and NLS Indexes
    ... And our query plan looks like this and completes in about 120 ms. ... 400 bytes received via SQL*Net from client ... sorts (memory) ...
    (comp.databases.oracle.server)
  • Re: Sort Multi Time Fields
    ... <MS ACCESS MVP> ... When it sorts now, it sorts numerically (ex: ... I do have the report sorting and grouping by date ... Save the query. ...
    (microsoft.public.access.reports)