Solved

Null field or not null field

Posted on 2013-02-03
3
408 Views
Last Modified: 2013-02-03
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
Comment
Question by:fordraiders
3 Comments
 
LVL 39

Assisted Solution

by:als315
als315 earned 100 total points
Comment Utility
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
 
LVL 10

Accepted Solution

by:
plummet earned 400 total points
Comment Utility
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
 
LVL 3

Author Closing Comment

by:fordraiders
Comment Utility
Thanks ! very much
0

Featured Post

Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now