I see now that it is a problem with date formatted fields. But I still don't
know how to format the fields correctly in the SQL View in order to get them
into a format that Word 2002 can read successfully.

Any ideas?

"Gelatinous_Blob" wrote:

I am attempting to filter records from a View in an SQL Server database using
the Mail Merge Recipients window in Word 2002 (SP3). I am attempting to
filter on a date range (e.g. registration_date 01/08/2004).

None of the query options get applied - instead Word returns all records in
the table. Is anyone aware of a work around? Is this a known issue with Word
2002? Or am I overlooking something obvious?