[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 426
  • 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

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

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