G
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...?
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...?