>Jon,
>
>Darn typo's.
>
>I took your advice and and tried the record selection formula "mc.date_cert = date(1899,12,30) but still no luck.
>
>To make sure I checked my table out again and out of a totla of 1,030 records there are 477 with no date in the date_cert field, so I know the table is okay.
>
>I tried this "mc.date_cert = date(1999,9,15)" and three records appeared in the report which is acurate.
>
>The "mc.date_cert = date(1899,12,30)" still shows no records :(
>
>There are no other selection criteria.
>
>This is a free table in the old fox2x type structure.
>
>I hope I'm not doing something stupid but I didn't think it should be this difficult.
>
Are you using ODBC to access the data? Crystal Reports will natively read a Fox2x table without going through ODBC.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer