Date/Time Format Changes On Exporting

[shep]

Using Office 2003
I am exporting a query to MS Word Merge File. In the query and its table,
date and time are formatted as medium. When I use the file for merge into
Publisher or Word, the date is short and time is long.

How can I keep the formatting from ACCESS?

Thanks

 

[Rick Brandt]

Using Office 2003
I am exporting a query to MS Word Merge File. In the query and its
table, date and time are formatted as medium. When I use the file
for merge into Publisher or Word, the date is short and time is long.

How can I keep the formatting from ACCESS?

Formatting with the format property is for screen display only. To export a
particular format you need to use the Format() function.

 

[shep]

Thank you

Formatting with the format property is for screen display only. To export a
particular format you need to use the Format() function.