running32
asked on
Sum a null value in Access
I am trying to Sum an Expression in Access, but one of the values may be NULL. How can I add a numer and still get a result even is one is Null. Expr2: [countoflngPassesused]+[Co untOflngme mberid]. thank you
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.
Sorry ... typo in first post ... see my 2nd post
ASKER
Thank you
mx