Sort order?

[organicpatti]

How do I get my Product Lookup Query to sort my item numbers to list 1,2,3,4,
5,6,7,8,9,10,11 and so on? (When I select ascending it lists out as 1,10,100,
1000,2,20,etc.) I need the list of products by item number like we count in
real life, what is the secret? I would also like for it to sort some alpha
product id ahead of the numbers, also, if at all possible.
Thanks for anyones help.

 

[David F Cox]

ORDER BY [YourPrefix], VAL([YourTextNumberField])

 

[organicpatti via AccessMonster.com]

What goes in the [YourPrefix] ? I have taken a few online classes, please
explain further.
I assume the 2nd half would be VAL([ProductSvcItemNo]) - which is my
TextNumberField.
I am not sure where this expression would be placed.
Thanks so much for your time to explain. I have a select query for my 3000
products. Some of my product and services item nos [ProductSvcItemNo] are
101 to 99999: and I have a group that are like AC15. I want the alpha first
then 101 thru 99999 in regular numberic order. Would the expression go in
the Sort or Criteria rows? I know I can do it if you can tell me a little
more elementry. Thanks again for helping me. Patti

ORDER BY [YourPrefix], VAL([YourTextNumberField])

How do I get my Product Lookup Query to sort my item numbers to list
1,2,3,4,

[quoted text clipped - 5 lines]

product id ahead of the numbers, also, if at all possible.
Thanks for anyones help.