Mail merge

  PEG007 19:53 30 Jan 07
Locked

When merging data from an Access dataset, times print as "long time" and not as the "short time" as formatted in the Access database eg 10:30AM merges as 10:30:00AM.
How do I get "short time" in the Word merge document?

  lotvic 23:44 30 Jan 07

On this page click here

it says to do this:
"Use the Format function to control how the time is formatted. In your code,
surround the variable that contains the time value with this (assuming the
variable is called varTime):

Format(varTime, "hh:nn am/pm") "

This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac