SQL Between Query Not Correct

Please see attachment, can you tell me what im doing wrong, it should only display 1 result which is the last record that is displayed, why is it showing the other 2 and how do i stop this?

Change the data type of IP1 and IP2 into something numeric.

Ah, Thank you very much Guido2004 :slight_smile: