Numbering

[Guest]

This is a problem I have had for a while: I have a column formatted as a
number, when I enter the values e.g. 95, 105, 10021 etc. they will not list
numerically. The 30's, 300's and the 30000's all group together. Is there
anyway to format the number so that they will group numberically, by looking
at the whole number and not just the first number? I tried doing it as a text
field, but that is not what I want to do.

 

[tina]

"formatting" does not affect a field's data type. from your description,
sounds like the DataType of the field in the table is Text, which treats
numbers as text characters and sorts them alphabetically. to get true
numeric sorting, change the field's DataType to Number. if your numbers will
all be "whole" numbers (no fractions), set the Field Size property to Long
Integer; otherwise, set it to Double.

hth