Not Expression

[David G. Hoch]

I feel a little silly asking such a simple question, but I've spent a lot of
time and have not come up with the right answer on my own.

I'm building a query in Access 2003. I have a field named "TCP/IP Address".
The field contains one of three types of data
1) A TCP/IP address (i.e. 192.168.1.1)
2) The letters "DHCP"
3) Left blank

My goal is to extract only those records that have a TCP/IP address.
I've gotten to the point where I can eliminate the blank records by using
the criteria <>""
Now I just need to find the correct syntax to tell Access to eliminate
anything that contains the letters "DHCP".

Can someone help an Access novice.

Thanks.
David

 

[Roger Carlson]

<>"" AND <>"DHCP"

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[fredg]

I feel a little silly asking such a simple question, but I've spent a lot of
time and have not come up with the right answer on my own.

I'm building a query in Access 2003. I have a field named "TCP/IP Address".
The field contains one of three types of data
1) A TCP/IP address (i.e. 192.168.1.1)
2) The letters "DHCP"
3) Left blank

My goal is to extract only those records that have a TCP/IP address.
I've gotten to the point where I can eliminate the blank records by using
the criteria <>""
Now I just need to find the correct syntax to tell Access to eliminate
anything that contains the letters "DHCP".

Can someone help an Access novice.

Thanks.
David

Where Tablename.[TCP/IP Address] Is Not Null Or Tablename.[TCP/IP
Address] Not Like "*DHCP*"

 

[David G. Hoch]

That did it.
Thanks for your help.
--David

<>"" AND <>"DHCP"

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L