Mail Merge Time Problems

M

Mark

While that solves one problem ... I would still want to
have the Null arrival time (in Access database) to show up
as Null in the mail merge document. Is that possible?

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.
 
P

Peter Jamieson

Are you saying you would rather Null turned up as "" without having to do
the Word IF field? In which case, follow this:
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.
Click to expand...

e.g. (off the top of my head) something like

SELECT iif(isnull(ArrivalTime),'',ArrivalTime) AS `newArrivalTime` FROM
mytable

or

SELECT iif(isnull(ArrivalTime),'',format(ArrivalTime,'MM/DD/YYYY') AS
`newArrivalTime` FROM mytable

Or are you looking for something else?
 
Top