morinia
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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
iif(left(fieldA,1)="V" OR FieldA is Null, ValueIfTrue, ValueIfFalse)