Date format changing during Access to Word Merge

[turns20]

Hi,
I currently have an automatic merge running of multiple access queries. This is all working fine except for one of my queries takes a date value which in the Access table is set to "medium date", eg. 14-Oct-03, when it merges into a word document it returns the format as a long date including the time. Any ideas how i can change this, the long date does not display anywhere in my tables in access. Any suggestions appreciated.

 

[KenReay]

Hi

Maybe in the query, you could use FORMAT() to force the date to a give style, this will present a string to your word merge however, if that is relevant to your situation

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK