Inserting a date into a table

C

CD Tom

I'm inserting a person into a table and everything is going ok except when I have a blank birthdate. I have a var called CDOB, in the insert statement it looks like this #" & cdob & "# this works fine when I have a actual date but not all individuals are giving a DOB. What's the best what to enter this. Right now I'm check the var for null and if so I change it to a 01/01/1901 date but would like to just leave it blank

Any help would be appreciated

Tom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to cut a paragraph that's followed by a table 2
Inserting shape to Header when table exists - anchor problem - Word VSTO 1
Insert Index into a Table 1
Autofill Date in Word 15.33 for Mac 0
SQL 2
Publisher is filling blank lines with data 2
Multiple Criteria in Listbox 3
Retrieve variable from website 0

Top