I have setup and linked an Access query and a Word document.
In Access I have formated using Medium Date format 23-Oct-10 but after
importing I get 10/23/2010.
I have tried to search but I can not work out the formatting
instruction on importing.
The Field is <<EDate>>
Any ideas please

Cheers
Duncan

In query design, type an expression like this into the Field row:
Format([SomeField], "Medium Date")

This will create a text field, and Word should handle that correctly.

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Duncan" wrote in message
news:d03ffa81-e056-4dad-94b6-b9c8fd842681 (AT) j4g2000prm (DOT) googlegroups.com...

I have setup and linked an Access query and a Word document.
In Access I have formated using Medium Date format 23-Oct-10 but after
importing I get 10/23/2010.
I have tried to search but I can not work out the formatting
instruction on importing.
The Field is <<EDate>>
Any ideas please

Cheers
Duncan

Thanks Allen
That worked well.
Cheers


On Oct 23, 3:48*pm, "Allen Browne" <AllenBro... (AT) SeeSig (DOT) invalid> wrote: