Mail Merge Prob

Hi Folks,

I'm using a mail merge form an access database using a simple query to bring
in table data (Medium Time in AM PM format) into a word document. All works
well but I've set up the database for Medium times AM PM format but when the
time is merged with word it shows the time as 24HR Long time e.g. "15:00:00"
instead of the desired "3:30 PM"

There is no VB code behind the document and there is no formatting code in
the databse other than the table design preset.

Any Suggestions??

Cheers

John

johnnybhoy
Thu Aug 14 12:08:34 CDT 2003

Doug your a star! Worked perfectly

Thanks a lot

John

"Doug Robbins - Word MVP" <dkr@mvps.org> wrote in message
news:uO8dzDkYDHA.1580@tk2msftngp13.phx.gbl...
> Hi John,
>
> Press Alt+F9 to toggle on the field codes in the mailmerge main document
and
> then add the following formatting switch inside the closing }
>
> \@ "h:mm am/pm"
>
> Please post any further questions or followup to the newsgroups for the
> benefit of others who may be interested. Unsolicited questions forwarded
> directly to me will only be answered on a paid consulting basis.
>
> Hope this helps
> Doug Robbins - Word MVP
> "johnnybhoy" <johnnybhoy67@excite.com> wrote in message
> news:OUxsMLbYDHA.3248@tk2msftngp13.phx.gbl...
> > Hi Folks,
> >
> > I'm using a mail merge form an access database using a simple query to
> bring
> > in table data (Medium Time in AM PM format) into a word document. All
> works
> > well but I've set up the database for Medium times AM PM format but when
> the
> > time is merged with word it shows the time as 24HR Long time e.g.
> "15:00:00"
> > instead of the desired "3:30 PM"
> >
> > There is no VB code behind the document and there is no formatting code
in
> > the databse other than the table design preset.
> >
> > Any Suggestions??
> >
> > Cheers
> >
> > John
> >
> >
>
>