Not Equal to Criteria

[John Gavin]

I'm stumped. I added a text field to my membership database
(Access 2000) and placed a d in all of the member records
who have not renewed. Using the simple query wizard I put
in the pertinent fields from the table, then specified Not
d which should have pulled up every record without a d.
When I ran the query it only brings up one record and that
record is blank. If I change the criteria to "d" and run
it, it will pull up all records that have the d just fine.
But I need to pull everything up that dosen't have the d so
I can make mailing labels. I tried <>"d" also, same story.
Any ideas? Thanks!

 

[Ken Snell [MVP]]

Not Like "d"

Try the above as a criterion expression.

 

[John Vinson]

I'm stumped. I added a text field to my membership database
(Access 2000) and placed a d in all of the member records
who have not renewed.

Into what field did you put the d? Is it a one-byte text field used
just for this purpose, or are you adding a d to other existing text in
a field?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[John Gavin]

It's a one-byte text field used just for this purpose. I
tried Ken's suggestion of Not Like "d" but it didn't work
either.

 

[Ken Snell [MVP]]

Can you post the properties of this text field? And post the SQL statement
that works (finds "d")?

--

Ken Snell
<MS ACCESS MVP>