Queries

[Darlene]

I am using a word merg document with a query from excel. a column of 6 digits , current format, *603475* comes through as *603475.0* and the column with a date format comes through with the date and time.

Any suggestions as how to get this query to work properly with the correct format.

 

[Doug Robbins - Word MVP]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


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

I am using a word merg document with a query from excel. a column of 6

digits , current format, *603475* comes through as *603475.0* and the column
with a date format comes through with the date and time.

 

[Darlene]

I have got the 6 digit column to come up right but for some reason the date I can not get to come up as "October 10,2004" without the time attached.

 

[Doug Robbins - Word MVP]

Have you tried using a

{ MERGEFIELD datefield \@"MMMM D, YYYY" }

switch?
--
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

I have got the 6 digit column to come up right but for some reason the

date I can not get to come up as "October 10,2004" without the time
attached.