Jill,
>The key field is called "invoice" and is character 20. the Date/Time field is just that and called procdate. It is the same in the header and detail files. Could it be that fox's SQL Select doesn't recognize the date/time field type? What is strange is that it seems to work sometimes and not others.
Please post your SQL SELECT statement.