I have setup an employment posting page where our users enter jobs we are posting. One of the optional fields is an expiration date field. I've allowed them to either leave this blank or put in a date. This works fine if you leave it blank, or if you put in a date. The problem arrises when you put in a date and then later decide you don't want to have a date anymore. I just don't know how to update the field so that the date is set back to a blank entry, I'm trying to use an UPDATE query for Microsoft Access...<BR><BR>If I try to do something like "ExpirationDate = ##, " then I get this error: "Syntax error in date in query expression '##'."<BR><BR>And if I try "ExpirationDate = ''" I get this other error: "Data type mismatch in criteria expression".<BR><BR>So how do I get this field set back to nothing?