Problem with IP Sorting even with leading zeros

[shyler82]

I have a col named IPAddress. I have addresses in the from
010.107.006.194 containg leadings zero.I have 2 IP Address like this
010.107.006.194. I am trying to sort it but the problem is that the
same IP Address doesnt come consecutive. One is in the middle and
other is after this IP Address which is as follows for 2nd same IP.

010.251.000.255
010.107.006.194
129.192.150.000

I dont want like this as 2 similar IPs should be consecutive.. How can
i fix this problem. Can anyone help me out please?

 

[KARL DEWEY]

Are you sorting in a query, form or report?
As you know any sort done in a query does not flow through the report. You
must use the report Sorting and Grouping.

 

[shyler82]

Are you sorting in a query, form or report?  
As you know any sort done in a query does not flow through the report.  You
must use the report Sorting and Grouping.
--
KARL DEWEY
Build a little - Test a little





- Show quoted text -

i am doing sorting right in the table by selecting a filed and apply
sort...

 

[KARL DEWEY]

You should not do work in a table.

Do you by chance have leading spaces?

 

[shyler82]

You should not do work in a table.

Do you by chance have leading spaces?

--
KARL DEWEY
Build a little - Test a little






- Show quoted text -

nop.. there are no leading spaces...we are using table to directly
insert data at theend and the sort to make it nice but this thing not
working

 

[KARL DEWEY]

If it sorts correctly in a query or in a report sorting and group that all
that matters.