Number order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that i am using to group data with (ie tyres, rims, etc). In order to get a report in the right order for my needs I have called the data (1) Tyres, (2) Rims etc. Unfortunately the order in report goes (1), (11), (12), (2), (3) etc. Is there anything I can do about this?
 
If you have set up a field in a table that contains the number for the row,
open the table in Design View, and change the Data type of the column from
Text to Number. It will then be sorted in numeric order.

If you are using a calculated field, use CLng() or similar to coerce Access
into treating it as a number. For more information, see:
Calculated fields misinterpreted
at:
http://allenbrowne.com/ser-45.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

TAGFC said:
I have a field that i am using to group data with (ie tyres, rims, etc).
Click to expand...
In order to get a report in the right order for my needs I have called the
data (1) Tyres, (2) Rims etc. Unfortunately the order in report goes (1),
(11), (12), (2), (3) etc. Is there anything I can do about this?
 
Back
Top