?
Solved

Quesry to find only Null fields

Posted on 2011-03-15
4
Medium Priority
?
364 Views
Last Modified: 2012-05-11
I am trying to query a table and find only those records that have a null in the Proj_ID field

the end of SQL statement is
WHERE (((tblLocalProject.[Proj_ID])=Nz([Proj_ID])));

what this returns is all records that don't have a null

0
Comment
Question by:ChuckRush
  • 2
4 Comments
 

Author Comment

by:ChuckRush
ID: 35140471
Sorry abotu the typing -- multi-tasking -- Query!
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 35140493
select * from
tblLocalProject
where tblLocalProject.[Proj_ID] Is null
0
 
LVL 75

Assisted Solution

by:DatabaseMX (Joe Anderson - Microsoft Access MVP)
DatabaseMX (Joe Anderson - Microsoft Access MVP) earned 500 total points
ID: 35140575
To also cover the case of Empty String ("") as well as Null ... you can use:

WHERE Nz([tblLocalProject].[Proj_ID] , "") = "" 
0
 

Author Closing Comment

by:ChuckRush
ID: 35140620
Thanks Guys! I was using isnull()   and it was an issue
0

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

589 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