Yep, I know you are right; it's a little incovenient, but this is how it is. Once you know what's really going on, it's no problem to move forward. Thank you for the explanation.

>That's what you have to do. Most "real" databases (and Access pretends to be a "real" database) do not accept empty dates. Dates (or datetimes) have a value or they are null.

>If the database will not accept null, you must supply a populated date.

>This is one place where Foxpro data is fundamentally incompatible with every other database system. VFP is the only place where EMPTY() is a valid value for a date or datetime field.

>If you can't pass null, you have to provide a valid date value.

>Dan