>Jim,
>
>Exactly which ODBC driver are you using to access this table? I'm using VFP's driver (VFPODBC.DLL) version 6.01.8629.01 and I tried testing using the DSN configured to look at a database (DBC) and as a free table directory. I get successful results with both.
>
>Which version of Crystal are you using? I'll e-mail you a zipfile of a free table and report I created so you can see it in action. Maybe that will help.
>
>Laterness,
>Jon

Jon,

I'm not using any ODBC driver as the mc.dbf is a fox2x typr free table. I tought with fox2x tables you didn't need the ODBC? Would that make a difference with the date format in CR?

My Crystal Reports is v8.0 but I'm thinking of getting the upgrade to v8.f.

I sure would like to have the zip file, once I see what's going on I should be able to figure it out.

Thanks,

Jim