Report sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Mike said:
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.
Click to expand...


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
 
Back
Top