Search results

Hello folks! I created a query to select only odd and even numbers using MOD 2 = 0 or 1 and it works fine. I set up this numeric field to sort ascending. But my sorting is wacko. Please help! When I run the code, I get 1, 11, 12, 2, 20, 22, 3, and so on. The same when I do the even sort, 2, 20...

I'm in Oregon. Portland area. Have programmed using Access 2000. Having fun learning the idiocincracies <sp> of Access 2010. Am familiar with SQL and vb6. Looking forward to learning new things from all of you. :rolleyes: Take Care, Terry Gefael