Access query problem

[SkippyjonJones]

I have a table and want to do an update query on one of the fields.

 

Lets say the field one (assignment) currently has only 2 possible entry’s – “A” or blank

Field two (treaty) has a load of different data but I’m only interested in the ones that have a particular entry (“831”)

I want to run a query where field two is “831” and field one is not like “A”.

 

 

So I run the following (currently showing as a select query)

 

SELECT Table1.assignment, Table1.treaty

FROM Table1

WHERE (((Table1.assignment) Not Like "a") AND ((Table1.treaty) Like "831"));

 

Why the frig won’t it work?

 

If I run just one criteria or the other its fine.

 

It works if both are LIKE statements but not if one is a NOT LIKE statement.

 

 

Ideas?

Using access 2002 (yeah – I know…)

[Mike]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Nebraska Red]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[KentyRed]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Edited May 12, 2011 by ScouseMouse

[carrafan]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[SkippyjonJones]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here