Problem with IP Sorting even with leading zeros

  • Thread starter Thread starter shyler82
  • Start date Start date
S

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?
 
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.
 
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 -
Click to expand...

i am doing sorting right in the table by selecting a filed and apply
sort...
 
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 -
Click to expand...

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
 
If it sorts correctly in a query or in a report sorting and group that all
that matters.
 
Back
Top