Numerical arrangement.

[Tim]

Hi, I'm using Access 2000, primarily in datasheet view to
organize about 250 entries a day, and they need to
be "organized" by a part number, ranging from 3 to 6
digits. As far as I can tell, access can't arrange them
in order of value, it treats them like decimals. If I
have 702, 7895, 3251 and 105443, access will arrange them
105443
3251
702
7895
or if I choose descending order, they will go the other
way. Is there ANY way in Access 2000 (this is on a
company-owned computer and upgrading Access is not an
option at this point) that I could make it arrange items
in the order of the actual VALUE of the number, ie:
702, 3251, 7895, 105443? The built-in help contains
nothing I can find on this.

 

[Rick B]

Sounds like your part number field is a text field not a numerical field.

To sort by the numerical value, add a new field to your query with something
like the following and sort by it...

SortValue: Val([PartNumber])



Rick B


Hi, I'm using Access 2000, primarily in datasheet view to
organize about 250 entries a day, and they need to
be "organized" by a part number, ranging from 3 to 6
digits. As far as I can tell, access can't arrange them
in order of value, it treats them like decimals. If I
have 702, 7895, 3251 and 105443, access will arrange them
105443
3251
702
7895
or if I choose descending order, they will go the other
way. Is there ANY way in Access 2000 (this is on a
company-owned computer and upgrading Access is not an
option at this point) that I could make it arrange items
in the order of the actual VALUE of the number, ie:
702, 3251, 7895, 105443? The built-in help contains
nothing I can find on this.