MS Access sort problem
Posted on 2009-04-10
I have a field that will contain unique numbers to identify an item in the following format
This field will be used to link tables with a one to many relationship.
I need the decimal places to always show the zero at the end if it applies
I would like to sort these based on the numerical values displayed in the field
I defined Field Size to Long Integer
If I define as a Number data type with a Format of ###.000 decimal places 3, entries are rounded up to the next whole number with zeros in the decimal places.
If I define as a Number data type with a Format of ###.##0 Access automatically changes it to #.000 with the same results as above.
If I define as a Number data type with a Format of ###.### the rounding to the next whole number happens.
If I do not supply a format then only a whole number is shown even if decimal values are entered.
If I define the field as a Text data type then the sort of course is not numerically correct.
I am hoping it something simple that I am missing otherwise a work around to make this happen would be great.