I'm returning a recordset using DAO that contains a date field. In some instances (like a date value is more than 1 year old), I want to null the field in the recordset.
I've tried !Date = vbNull, but all that does is enter 12/31/1899 in the field. I want it to be null. Any suggestions?