sortering på en ipadresse

this is because it is a text field.

You need to make a routine which splits your IP address into 4 numbers and then sorts on those. you also need to remember that each part of the IP address can be three digits so the problem is NOT only for the last number!

Du kan jo vælge at lagre dem i et tekstfelt som:
  172.020.040.008
  172.020.040.120
så vil rækkefølgen blive rigtig!

Eller som Terry siger: 4 byte-felter, som derefter kan sorteres! (derved undgår du de foranstillede nuller)

it the first time i use databases - can you give an example how i split one field into four

you can use the MID function (LOOK UNDER HELP).