ascending criteria

[JohnLute]

Here are the two tables and pertinent fields I need to report:
tblFinishedGoods
txtProfileID (PK)

tblFGUnitLoadLayerParameters
txtProfileID (PK)
txtLayer (PK)

I use sfrmFGUnitLoadLayerParameters to make entries into
tblFGUnitLoadLayerParameters. cbLayer is a value list:
"All";"Even";"Odd";"1";"2";"3";"4";"5";"6";"7";"8";"9";"10";"11";"12";"13";"14";"15";"16";"17";"18";"19";"20"

I'd like my report of cbLayer to ascend. This creates the problem of "10"
following "1" as well as "20" following "2":
1
10
2
20
3
4
5

How can I set this up so that the numeric sequence is truly ascending:
1
2
3
4
5
10
20

Any help is appreciated - THANKS!!!

 

[MA]

Here are the two tables and pertinent fields I need to report:
tblFinishedGoods
txtProfileID (PK)

tblFGUnitLoadLayerParameters
txtProfileID (PK)
txtLayer (PK)

I use sfrmFGUnitLoadLayerParameters to make entries into
tblFGUnitLoadLayerParameters. cbLayer is a value list:
"All";"Even";"Odd";"1";"2";"3";"4";"5";"6";"7";"8";"9";"10";"11";"12";"13";"
14";"15";"16";"17";"18";"19";"20"

I'd like my report of cbLayer to ascend. This creates the problem of
"10" following "1" as well as "20" following "2":
1
10
2
20
3
4
5

Taht sorting is because the field is text

How can I set this up so that the numeric sequence is truly ascending:
1
2
3
4
5
10
20

Any help is appreciated - THANKS!!!

Convert in Integer
CInt(yourfield)

--
_ _
Ciao
MAssimiliano Amendola www.accessgroup.it
Cisa1 - I° Conferenza Italiana per Sviluppatori Access Arezzo 4+5
Giugno 2005 Sono aperte le iscrizioni Info: www.donkarl.com/it

 

[JohnLute]

Thanks, MA.

Is there any way around this?