sequencing fields in access

[Guest]

I have an access document that has 6 feilds. One of the fields is numeric in
nature. The fields have values of 1-1, 1-2 1-3 ... through 1-87. The
document is alphabetically sequenced based on a different feild. When I
click on this field to sequence them it comes out like this:
1-1
1-10
1-11
1-12
1-13
1-14
1-15
1-16
1-16
1-17
1-18
1-19
1-2
1-20

How or what can I do to be able to sequence these fields 1-1, 1-2 1-3 etc...?

 

[tina]

One of the fields is numeric in

nature. The fields have values of 1-1, 1-2 1-3 ... through 1-87.

you may be entering number characters in the field, but its' data type is
Text. a text field will be sorted as text, even when the characters entered
are numbers, and return the result that you posted. to get a numeric sort,
as

1-1
1-2
1-3
1-10
1-11
1-20

suggest you use two fields, one for the digit before the hyphen, and the
other for the digits after the hyphen. in the table, make sure that the data
type of both fields is set to Number, not Text. sort by the first field,
then by the second field. for display purposes, you can concatenate the two
fields, as

Field1 & "-" & Field2

hth

I have an access document that has 6 feilds. One of the fields is numeric in
nature. The fields have values of 1-1, 1-2 1-3 ... through 1-87. The
document is alphabetically sequenced based on a different feild. When I
click on this field to sequence them it comes out like this:
1-1
1-10
1-11
1-12
1-13
1-14
1-15
1-16
1-16
1-17
1-18
1-19
1-2
1-20

How or what can I do to be able to sequence these fields 1-1, 1-2 1-3

etc...?