Report sorting

[Guest]

When I try to sort a field of address numbers in a report, the numbers are
sorted like you are soring in windows,
1,12,14,15,16,20,20,21.3,30,32,32,4,4,40,41...
any idea to get them to sort normaly in numeric order.

 

[Marshall Barton]

When I try to sort a field of address numbers in a report, the numbers are
sorted like you are soring in windows,
1,12,14,15,16,20,20,21.3,30,32,32,4,4,40,41...
any idea to get them to sort normaly in numeric order.

That's because it's a text field. You can use an expression
in Sorting and Grouping. Try using:

=Val(addressfield)

But what if you have something like my old address
0S435 Florida Lane