Solved

Quesry to find only Null fields

Posted on 2011-03-15
4
307 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 119

Accepted Solution

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

Assisted Solution

by:DatabaseMX (Joe Anderson - Access MVP)
DatabaseMX (Joe Anderson - Access MVP) earned 125 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

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
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…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

757 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

22 Experts available now in Live!

Get 1:1 Help Now