>In regard to guarding against NULL values which bomb your program, how do you then send a date data type into an MSACCESS table from VFP when the field it is coming from is a DATE data type but it's going into a DATETIME data type. And, the date field is empty. This bombs when trying to insert it into an ACCESS table, coming out as an unacceptable NULL value.
Cecil,
What you use to communicate with ACCESS?
RVs,
CAs or SPT?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.