al4629740
asked on
Null Statement Correct??
In this sql string, is the portion that looks for a null value correct on the last line?
esql = "Select * from " & c & " Where StartDate >= " & pound & a & pound
esql = esql & " And StartDate <= " & pound & b & pound
esql = esql & " And (SchoolWorkplaceBehavior = 0 Or SchoolWorkplaceBehavior = Null) "
esql = "Select * from " & c & " Where StartDate >= " & pound & a & pound
esql = esql & " And StartDate <= " & pound & b & pound
esql = esql & " And (SchoolWorkplaceBehavior = 0 Or SchoolWorkplaceBehavior = Null) "
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.