I need to set a field in Access to Null, through SQL, but after setting this field, it gets the value Zero and not Null. Due to a business rule, I need this field to be NULL and not Zero. The field is numeric.
Null value displaying zero MS Access
0
asked by anonymous 06.12.2016 / 20:35
2 answers
0
Usually Access goes with NULL when used inside a SUM; Another possibility is that you may have put a DEFAULT 0 in your field;
There is an answer about something similar in this link .
12.12.2016 / 19:28
0
This setting should work (default setting):
13.04.2017 / 20:22