Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Filter Merge Data by Date Range
Hi Guys,
I'm merging with an SQL table, which includes a date column. And I need to merge the records for a specific day only. The date column is formatted as '2007-12-31' (yyyy-mm-dd) and includes a time stamp 00:00:00. But when I use "Filter & Sort" in Word, I cannot get it to filter by the date at all. No matter what varations of operators & values I try, it won't filter the results. I know I could create a View in SQL, but I'd like to find a Word based solution. Thanks for your input. Kind regards Stuart Sydney, AUSTRALIA |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Filter Merge Data by Date Range
The trouble is that Word tries to generate the wrong syntax SQL code, then
gets confused (as far as I know). Also AFIK, the only approach to a solution other than using a view is to issue your own SQL in Word VBA, e.g. ActiveDocument.MailMerge.OpenDataSource _ Name:="the pathname of the .odc file you are using to connect", _ SQLStatement:="SELECT * FROM [mytable] WHERE [mydate] = '2007-12-31' Peter Jamieson "Stuart Troy" wrote in message ... Hi Guys, I'm merging with an SQL table, which includes a date column. And I need to merge the records for a specific day only. The date column is formatted as '2007-12-31' (yyyy-mm-dd) and includes a time stamp 00:00:00. But when I use "Filter & Sort" in Word, I cannot get it to filter by the date at all. No matter what varations of operators & values I try, it won't filter the results. I know I could create a View in SQL, but I'd like to find a Word based solution. Thanks for your input. Kind regards Stuart Sydney, AUSTRALIA |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Filter Merge Data by Date Range
Thanks Peter,
I used a similiar solution, using the DATABASE field with an SQL query. It works nicely. Thanks again. Stuart Sydney, AUSTRALIA |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge Prompt date range query | Mailmerge | |||
How do I print documents from a folder within a certain date range? | Microsoft Word Help | |||
How do I change the date range on a calendar template in Word | Microsoft Word Help | |||
Date range | Microsoft Word Help | |||
How do I filter a Dbase date field in a word mail merge documnet? | Mailmerge |