Mail Merge Date/Time

[Mark]

I have a mailmerge listing generated from an Access
database which includes among other data, Name, Airline &
Arrival Time. The problem I have is that even though the
database shows a blank for Arrival Time, the mail merge is
filling in 12:00:00 AM. I try to do some Next If keying
on a Null field, but none are Null because of the 12am.
Records with times in the database show up fine ... just
the null ones are problems. Is there anyway that records
with null in the database can be made to stay null in the
mail merge document? Thanks

 

[Peter Jamieson]

Instead of testing for null, try testing for the string 12:00:00 AM
(although if you actually have Arrival time 12:00:00:00 AM that's not going
to be that helpful)

e.g.

{ IF "{ MERGEFIELD ArrivalTime }" = "12:00:00 AM" "" "{ MERGEFIELD
ArrivalTime }" }

Or you could create a query in Access which uses Access SQL functions to
return the date as a string in the format you want.