 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2007Time field format
I have problem with formatting time fields: Example: 30.12.1899 7:00:00 ...i want to display: 7:00 I try with this code: MERGEFIELD "Time" \@ "HH:mm" Source is MS Query. Thanks! I think the problem in this case is that Word does not recognise the incoming value 30.12.1899 7:00:00 as a date/time and does not even try to apply the format that you specified. What is the data source that you are accessing via MS Query? Which version of Word are you using? Peter Jamieson >I have problem with formatting time fields: > [quoted text clipped - 5 lines] > Source is MS Query. > Thanks! I use Word 2003, and data source accessed with MS Query is 4 Access queryes. > I think the problem in this case is that Word does not recognise the > incoming value 30.12.1899 7:00:00 as a date/time and does not even try to [quoted text clipped - 14 lines] > > Source is MS Query. > > Thanks! Is there a reason why you cannot connect directly to the data source (i.e. without using MS Query?) Peter Jamieson >I use Word 2003, and data source accessed with MS Query is 4 Access >queryes. [quoted text clipped - 18 lines] >> > Source is MS Query. >> > Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.