What to do. I get messed up with dates all the time.

I have a form that adds a record to an access db.

There is a form date field that may or maynot have a value in it.

If the form field is empty (no date entered,) and no value is passed the sql statement crashes.

What can I do to make this work? Is there a way of using an if statement in the sql statement to exclude adding a date when none exists? Or, is there another method to keep this from crashing on me?

I hope this makes sense..

Thanks for any help..

Chip

You would need an SP or a UDF to use if ... then in an INSERT query neither of which Access is noted for

simplest way would be to set a default value using ASP or not concat the column name and the value into the command string before sending the query

"not concat the column name and the value into the command string before sending the query" I think this is the way to go.

Thanks Chris. As always, I appreciate your help.