Update Query... query

[minii]

Hi Guys,

So basically I'm trying to create an update query and for the life of me can't workout why it's not working. Basically I have two tables Asset and IP. Asset uses a lookup to lookup the values from the IP table for IPs. Now in the IP table I have a yes/no field named "In Use". What I want to do is have an update query that when runs updates this to yes if an IP has been assigned to an Asset ID. My update query looks like so:

In Use.IP
Update to: Yes

AssetID.Assets
Criteria: Is Not Null

IP.Assets
Criteria: Is Not Null

Now I've tested that it can bring back data by creating a non update query version of it and it can (it's exactly the same). It displays exactly what I want. I can't see why it won't work. Interestingly enough I've done an update query that will set the In Use to no if Asset ID has no IP assigned and that works fine.

If anymore clarification is needed, feel free to ask.

Many thanks

 

[apr pillai]

Compare the Allow Zero Length Property Value settings of second and thrid table with Use.IP Field Property value setting.

 

[minii]

Asset ID is an autonumber and as such Allow Zero Length cannot be set with it. Any other suggestions? Many thanks.

EDIT: I seem to have achieved my goal with use of a 'few' find unmatched queries and a Union query.