I have a report linked to a Foxpro table.
When I link the table if the dates in Foxpro are blank they comes as time
over to Access. 12:00AM. The records have several fields with dates.

So if I choose one field with a date, and some other fields are blank they
show up as time:

eg
1st Date         2nd Date          Name
12/01/05       12:00AM         Oranges
12/01/05        12/30/05        Red

I want the 12:00AM on the report to show as blank.
How can I do that?

Thanks