>It looks you'll need to give me a hint. I'm still not getting anywhere.The way I've been able to do is to test for the field value against Date(1899,12,30). Checking for null values using IsNull() will not help at all since, as Craig pointed out, the ODBC driver is returning an actual value.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer