Report linked to Foxpro Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try using an IIF to set zero values to null

Field: FixedDate: IIF([2nd Date]= 0,Null, [2nd Date])

You might need to use
Field: FixedDate: IIF([2nd Date]= #12:00:00 AM#,Null, [2nd Date])
 
Back
Top