• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 431
  • Last Modified:

Null field or not null field

access 2010


I'm trying to up a field  primary_image2 from primary_image..


Alot of records will not update?
I have the "Zero Length" set to yes.




UPDATE Picture_NotAll SET Picture_NotAll.primary_image2 = [Picture_NotAll].[primary_image]
WHERE (((Picture_NotAll.primary_image2) Is Null));

Thanks
fordraiders
0
Fordraiders
Asked:
Fordraiders
2 Solutions
 
als315Commented:
Try to set Where also to Or Like "". May be it is not Null, but zero length string
Full Criteria string will be:
is Null Or Like ""
0
 
plummetCommented:
Hi

Are you getting an eror or just not the result you're expecting? Are you sure that all the primary_image fields have data? Also, you could try a different variety of the WHERE clause:

WHERE nz(Picture_NotAll.primary_image2,"")=""

This checks for NULLs and empty strings - ie if the field is null it returns an empty string, which you can then check for.
0
 
FordraidersAuthor Commented:
Thanks ! very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now