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?
It's worked in view mode, using
Nz([DOB],0) as part of the Expression.
Sets all where no DOB to 117 for some reason.
Still doesn't update the table though when run as append. Weird.
@rhb started
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
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?