[Last Call] Learn how to a build a cloud-first strategyRegister Now


Checking for Nulls in Access

Posted on 2014-08-18
Medium Priority
Last Modified: 2014-08-18

I have a where statement that needs to check :
Field A does not begin with "V"   or FieldA is null

What would the syntax be?
Question by:morinia
  • 2
LVL 10

Expert Comment

ID: 40268835
Try this:

iif(left(fieldA,1)="V" OR FieldA is Null, ValueIfTrue, ValueIfFalse)

Author Comment

ID: 40268855
How would this be done if it is at the end of a query in a where clause not and if statement.

I a trying to pull only those records where FIELDA does not begin with "V" OR FIELDA is null
LVL 10

Accepted Solution

etech0 earned 2000 total points
ID: 40268864
Oh! Try this:

WHERE left(fieldA,1)="V" OR FieldA is Null

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
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.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

831 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