There is not such a thing as '00/00/00'  
Also, Date fields on Pervasive are not Null/Empty  
To be honest no idea what they are  
 
I suggest you to use something like this to query Pervasive and download it to either MS Access or MS Excel  
 
SELECT  
MTWO_WIP_WOPRE AS WOPRE,  
MTWO_WIP_AFIN AS AFIN,  
SIGN (WEEK(MTWO_WIP_AFIN)) as MyNull  
FROM "WORKORD"  
 
There the column MyNull becomes a null value aka '00/00/00'  
 
ciao,  
 
Kelloggs

This SQL will return all rows that do not have a valid date:
 
SELECT "BKCMACCT"."BKCM_ACCT_START", "BKCMACCT"."BKCM_ACCT_CODE"
FROM "BKCMACCT"
WHERE "BKCMACCT"."BKCM_ACCT_START" not in  
(SELECT "BKCMACCT"."BKCM_ACCT_START"
FROM "BKCMACCT"
WHERE ("BKCMACCT"."BKCM_ACCT_START" > '1980-01-01'))
 
This uses a sub-query to create a list of rows that have a date.  by selecting all rows that are NOT IN this sub-query,
only the rows that have no date are returned.
 
This SQL could be used with Access or Crystal.

Well, thanks for what I guess is a great idea, but I have to reveal my ignorance of SQL. I tried fooling around with it for a while and couldn't get anywhere, except to prove that a little knowledge can be a dangerous thing. I ended up just sorting the records by start date, and all the ones that were blank showed up at the beginning of the report. It gave me what I needed even if it is crude.