Sorting Problem on report

  • Thread starter Thread starter MJJ
  • Start date Start date
M

MJJ

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.
 
Yours is a common problem and one that's not documented
well in Microsoft Access help files. However, it's
easily solved! The [ID] field on which you're sorting is
a TEXT field. If you change the data type to a numeric
field type (INTEGER, LONG INTEGER, etc.) your problem
should be fixed.

Good Luck,
John Whitney
 
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.
Click to expand...

The report is sorting correctly ...... if the ID field is Text
datatype.
If the ID is always a number (no letters in the field), you can either
change the ID datatype in the table to Number,
or in the report sorting and grouping dialog, sort by =Val([ID]).
 
-----Original Message-----
Yours is a common problem and one that's not documented
well in Microsoft Access help files. However, it's
easily solved! The [ID] field on which you're sorting is
a TEXT field. If you change the data type to a numeric
field type (INTEGER, LONG INTEGER, etc.) your problem
should be fixed.

Good Luck,
John Whitney

-----Original Message-----
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.
.
Click to expand...
.
The id field is a long integer. When I run the query the
Click to expand...
report is based on by itself, it sorts fine.
 
-----Original Message-----
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.
.
If this is supposed to be a text field, right justify
Click to expand...
the number and it will sort properly.
 
Back
Top