Null value showing zero MS Access

Asked

Viewed 550 times

1

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 numerical.

sql ms-access

  • You defined this field in what way? UPDATE tabela SET campo = NULL WHERE id = xx?

  • That’s right.....

  • How did you create this field? Put the DDL there

2 answers

1

This setting should work (default setting):

Propriedades do Campo

0

Normally Access disappears with NULL when used inside a SUM; Another possibility is that you may have put a DEFAULT 0 in your field;

There’s an answer about something similar in this link.

Browser other questions tagged sql ms-access

You are not signed in. Login or sign up in order to post.