asked on Checking for Nulls in Access
Experts,
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?
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?
Microsoft Access
Last Comment
etech0
ASKER
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
I a trying to pull only those records where FIELDA does not begin with "V" OR FIELDA is null
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
iif(left(fieldA,1)="V" OR FieldA is Null, ValueIfTrue, ValueIfFalse)