ODBC with a system DSN. I toggled the NULL setting in the properties of the DSN. It didn't seem to make a difference. If I set the select in Crystal to any value for the date field I get the 12/30/1899 date that I expect for a NULL.

>How are you connecting to the data? Direct access or ODBC?
>
>
>>Hi all,
>>
>>I am working on a report in Crystal Reports v9 looking for inventory items in a VFP free table where the item status is 'out', but there is no date for when the item went out. Of course the table has a blank and Crystal returns no records when I set the criteria to be {table.field} = (0,0,0). However there are way too many items that do not have an out date. How can I get Crystal to see the blank fields in FoxPro and give me the data that I want?
>>
>>I've played with formulas, IsNull, convert null in options and report options to no avail. Craig--you're the master, what is the path to enlightenment?