Sorting Order

[lmonroe]

I had one query I sorted as as ascending and it returned the way I want sorting as 1,2,3 I did it on another query and the order cam back 1,10,100...How do I get it to go with 1,2,3 as well? Why did it change they way it sorted? I didn't click anything different...

 

[John Big Booty]

Welcome to the forum.

I suspect that in the first query the field is numeric, whilst in the second query your field is text, or is being treated as text.

 

[lmonroe]

That fixed it! Thanks!