Division by zero in when I order by column number

[camdiggy]

So, I have some complicated calculations I am aliasing in my SQL query. My end goal would be to sort by my final calculation from all the other calculations I have performed but I am running in to some issues. I know I can't sort by referencing the alias itself without saying order by (column number). My calculations are usually pretty small (around .001 and up). Whenever I order by the column number I would like to use, (select...from...where...order by 73) I get a "Division by zero" error in access. I figured this was an issue with how small the calculations were, so I multiplied by 1000000, then ordered by that column number. Still division by zero...I went ahead and changed all 0 values to 1, still division by zero. There are no zero values in the column itself, it's either 1 or something in the thousands. I can order by other columns, just not the one I want to use. I don't want to have to re-do my entire calculations in my order by clause, so I was wondering if anyone had seen something like this or had any idea what I am doing wrong. Thanks!

[June7]

Totally unfamiliar with this. I have never referenced a column number in queries. If you want to provide db for analysis, follow instructions at bottom of my post.

[John_G]

I haven't seen order by column number either - can you post the SQL of the query?

[ssanfu]

I vaguely remember hearing/using this form of ORDER BY, but I couldn't find anything about it in Help.
I did find a couple of blogs about it:

http://connectsql.blogspot.com/2010/...n-name-or.html
http://blog.sqlauthority.com/2010/12...-columnnumber/

It is useful if you are trying to sort using a calculated field. But, as per the blogs, it is dangerous...