I'd rather not send anything if I don't have to but I don't know how I can write my Insert Statement for all the various possibilities.

Sending NULL to Access did do the trick I think. I just have to remove all the single quotes from my Insert SQL because Access would take

NULL

but not

'NULL'