Sorting Problem on report

From: MJJ (anonymous_at_discussions.microsoft.com)
Date: 06/09/04 

Date: Wed, 9 Jun 2004 06:07:21 -0700

In a report I sort on an ID. The id's start with 10 and
increase by 1 to whatever(10,11,12....). However when
sorted, the report shows 10,101,102...109,11,110,111,...119
etc. I would like them in sequence. What am I doing
wrong? I reviewed the sorting and grouping.

Relevant Pages

  • Re: What about an EXPLICIT naming scheme for built-ins?
    ... But having sortedto return a iterator ... sortedreturns a brand new sorted sequence. ... -- sorting long sequences to use only a few of the first elements. ... if you need to sort a long list to get the top 10 elements. ...
    (comp.lang.python)
  • RE: Sorting Dates
    ... If you want to sort on the date field, it should be a date data type. ... sorting or using in calculations. ... I am trying to re-do the report as we speak. ... "Duane Hookom" wrote: ...
    (microsoft.public.access.reports)
  • Re: "Convert in Integer" for MA or any guru, please!
    ... I thought you only wanted to sort the report by this value. ... in the sorting and grouping expression/field. ...
    (microsoft.public.access.reports)
  • Re: Selecting records matching user input
    ... Report order is controlled by the Sorting and Grouping dialog of the report. ... What I meant by SOMETIMES the sort order of the query works is just that. ... I have removed everything from Grouping and Sorting and now ORDER BY in my SELECT query is working as it should. ...
    (microsoft.public.access.modulesdaovba)
  • Re: "Sort" a combination of letters and numbers e.g. 20, 21a,200,
    ... The sorting for the report works beautifully, however, any VBA code ... Sometimes I will want to sort by a) area and then b) Tag, ... I only have one piece of code in my database so far, ...
    (microsoft.public.access.reports)