Member_2_7966563
asked on
MS Access query: A = B+C+D yields zero if either of B, C, D are blank
In MS Access, I have a table linked to an external Excel file. In that table I have three numerical columns. In MS Access I have a query that uses those 3 columns and adds a fourth field which is the sum of all three columns.
Here is my problem: it only works as expected when there is data in all three columns. If even one of the columns has a blank in it, then the sum field I added shows a zero.
How can I fix this?
Here is my problem: it only works as expected when there is data in all three columns. If even one of the columns has a blank in it, then the sum field I added shows a zero.
How can I fix this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you are welcome! glad I could help
ASKER