Problem with IP Sorting even with leading zeros

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?
 
K

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.
 
S

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...
 
S

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
 
K

KARL DEWEY

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

Linq Adams via AccessMonster.com

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

How exactly do you do that? "Sort" is not available when a table is opened!
It's grayed out!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top