Sorting ip address for dynamic table

Try this technique:
http://office.microsoft.com/en-us/access/HP011646131033.aspx

thanks I really apprecdiate your input... I added that code in, and it returned
the same error, but with CINT rather than CAST...

telling me there's a missing operator.

Mark



[q]Originally posted by: east99
-- Access:
SELECT CINT(column)
-- SQL Server:
SELECT CAST(column AS INT)

Try this:
SELECT [radio_ip] FROM [sc_survey]
ORDER BY CINT(PARSENAME([radio_ip], 4) AS INT),
CINT(PARSENAME([radio_ip], 3) AS INT),
CINT(PARSENAME([radio_ip], 2) AS INT),
CINT(PARSENAME([radio_ip], 1) AS INT)

Not sure, never tried to sort Ip addresses but am intereste in helping you
solve this.[/q]

I saw that one too, but it's seems almost too complicated.

I suggested since the data gets entered manually to have an (autonumber) field
called "sortorder" and sort on that, but he says no thanks.

Not sure, I may even bee seeing to deep into this one.

I saw that one too, but it's seems almost too complicated.

Too complicated? Are you talking about this:
http://office.microsoft.com/en-us/access/HP011646131033.aspx
That'll take a few minutes to implement. Creating and maintaining a sort
order manually is surely not the way to go.

using order should be simple, yet it seems so complicated.

I have no idea how to sort by IP ADDRESS but am willing to help.

sorting with the auto number would only work if I entred the ip's into the
database in order.

for example,

1 - 192.168.0.1
2- 192.168.0.7
3 - 192.168.0.5
4- 192.168.0.2

if I were to sort by the auto number, it sitll would not sort the ip's in
order.

if I had for example:

1 - 192.168.0.1
2- 192.168.0.2
3 - 192.168.0.3
4- 192.168.0.4


then I could do that.

But at the same time, I cannot add any more coloumns or change the structure
in an shape or form.

mark



[q]Originally posted by: bregent

I saw that one too, but it's seems almost too complicated.

Too complicated? Are you talking about this:
http://office.microsoft.com/en-us/access/HP011646131033.aspx
That'll take a few minutes to implement. Creating and maintaining a sort
order manually is surely not the way to go.[/q]

But at the same time, I cannot add any more coloumns or change the structure in an shape or form.

You don't need to. Did you read the link I posted?

Could I ask to see the structure of the table for the database in question?

I am at work, adn that was a 1200+ page document. I will read through it when I
get some time, but unless you know the page #, I will have to read it later.

thanks, mark

[q]Originally posted by: bregent

But at the same time, I cannot add any more coloumns or change the structure
in an shape or form.

You don't need to. Did you read the link I posted?[/q]

nothing special, for this talble, there is some location information, and a
cloumn with ip addresses. (among other coloumns) nothing fancy
thanks, mark


[q]Originally posted by: east99
Could I ask to see the structure of the table for the database in question?[/q]