You are reading a single comment by @rhb and its replies.
Click here to read the full conversation.
-
Cheers, looks like it could help if used as Nz() will try it tomorrow time allowing. http://www.techonthenet.com/access/functions/advanced/nz.php
rhb
It could be the null values that are causing the validation errors, can you stick an nvl() around the dob to populate it with a dummy value?