When I created the Service Table (ServiceT) in Lesson 6, by default Access set a Default Value of 0 for all the Number fields.
When I created the UnassignedServiceQ Query in Lesson 16, with "Is Null" as criteria for the ServicedBy field, the query was empty; as none of the "By" fields were null, they all contained a 0.
I then went back and removed the Default Value for the affected fields, and manually deleted the 0s in the sample records.
Adam Schwanz 3 years ago
Yes that's normal behavior for a number field to default to 0. If you have a choice it's probably better to not try to work with Nulls. In this case, the better way to handle the service query would be to have the Is Null criteria OR =0 (so it was never added)
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Security Seminar Lessons.
The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
