Unfortunately, there are some errors in Word in this general area.

In this case, the simplest workaround is probably to change the way that
Word connects to Excel: check Word Tools|Options|General|"Confirm
conversions at open", go through the process of connecting to your Excel
sheet again, and select the DDE option when it is offered. (warning - if you
have a multi-sheet workbook, DDE will only connect to the currently open
sheet, or if the workbook is closed, the last sheet you had open. Or
something like that).

It might seem strange that changing the connection method might fix this
problem, but Word takes your filter criteria and generates an SQL query from
them. Because it is actually using a different dialect of SQL when you
connect using DDE, and gets the query code right.

If you can't use DDE then the only way to fix this (as far as I know) is to
use VBA to issue the correct SQL. We can go into that if necessary.

Peter Jamieson