I have written an INSERT query that will let me save a new record from an unbound form to a table.
My issue is that I have two number fields and the INSERT query will not work if they are empty. I have allowed for Zero Length on my text fields, but there doesn't seem to be such an option for number fields.
Any idea how I can solve this issue?
Thank you, in advance.
My issue is that I have two number fields and the INSERT query will not work if they are empty. I have allowed for Zero Length on my text fields, but there doesn't seem to be such an option for number fields.
Any idea how I can solve this issue?
Thank you, in advance.