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.

[PC Datasheet]

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.