Query sort

[lb1]

When I make a sort in a query I get the following order:
1,12,19,2,30

How can I get a sort that is:
1, 2, 12, 19, 30

Is there a specific setup to do.
Thanks for any help.
Louis

 

[SgtJarrow]

your data you are sorting is "text"...that's why 19 comes before 2.

change the data type to numeric and you will be sorting correctly.

****************************
Computers are possibly the most un-intelligent things ever invented, yet we let them control the world. Possibly a reflection of our own stupidity.

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[lb1]

oops, Thanks

 

[dhookom]

You should be able to leave the data type as a string/text but sort based on Val([YourField])

Duane
MS Access MVP

 

[SgtJarrow]

sorry about the ambiguity....but that is what I meant. I was taught not to use numeric fields unles doing math...other wise use text and just use something like CInt([value]) to sort...

****************************
Computers are possibly the most un-intelligent things ever invented, yet we let them control the world. Possibly a reflection of our own stupidity.

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com