467,869 Members | 1,409 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,869 developers. It's quick & easy.

Query criteria - limiting the records - question

LFM
I have a table called "employee profile" which contains a bunch of user
information. In that table I have a field called "Description" which is a
text/memo field. This field is not mandetory to be filled in, so in many
cases the field contains a null value.

I would like to create a query that lists all the records that do not
contain the word "employed" anywhere within the description field.

I tried putting NOT LIKE "employed" in the criteria for the field, but that
does not work.

I realize this value ends up in the WHERE clause of the sql statement, so
what do I put in to find the "WHERE NOT LIKE "employed" in any part of the
field, but that also still returns the null values if they exist.

Note: This task is in effort to clean data before importing into another
larger database.
Nov 13 '05 #1
  • viewed: 1268
Share:
1 Reply
You were very close!

NOT LIKE "*" & "employed" & "*"

Returns all descriptions that contain the word 'employed' with anything
before the word and anything after the word.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"LFM" <no******@nothanks.com> wrote in message
news:19******************************@40tude.net.. .
I have a table called "employee profile" which contains a bunch of user
information. In that table I have a field called "Description" which is
a
text/memo field. This field is not mandetory to be filled in, so in many
cases the field contains a null value.

I would like to create a query that lists all the records that do not
contain the word "employed" anywhere within the description field.

I tried putting NOT LIKE "employed" in the criteria for the field, but
that
does not work.

I realize this value ends up in the WHERE clause of the sql statement, so
what do I put in to find the "WHERE NOT LIKE "employed" in any part of the
field, but that also still returns the null values if they exist.

Note: This task is in effort to clean data before importing into another
larger database.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Guy Erez | last post: by
3 posts views Thread by Steve | last post: by
10 posts views Thread by Kenneth | last post: by
3 posts views Thread by Josh Armstrong | last post: by
6 posts views Thread by Martin Lacoste | last post: by
1 post views Thread by lorirobn | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.