Sorting of text to number conversion

[Sophia]

Hi Everyone: I have a text that I am trying to convert to a number, so that
I can sort it numerically.

This is in the query:

No: Format(Val(nz([Pound_Sheet_No],0)),"0")

The problem is that it sorts as follows:

100
120
13
14
1400
15
150
16

Any suggestions to have it sort numerically?

Sophia

 

[Jerry Whittle]

No: Val(nz([Pound_Sheet_No],0))

 

[Sophia]

Thanks. I did try that too. But I just realized that the problem was that
when I tried to sort by numbers under a certain number, I put quotes around
it....
eg <"50000" instead of <50000

No: Val(nz([Pound_Sheet_No],0))
--
Jerry Whittle - MS Access MVP 2007 - 2009
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder

Hi Everyone: I have a text that I am trying to convert to a number, so that
I can sort it numerically.

This is in the query:

No: Format(Val(nz([Pound_Sheet_No],0)),"0")

The problem is that it sorts as follows:

100
120
13
14
1400
15
150
16

Any suggestions to have it sort numerically?

Sophia