Chris,
I've just tested this with a simple table and it worked fine. A few things to check/try:
- If you don't put a filter, what are the values you see in this column?
- Try with a very simple query (single table)
- What version of MS Query are you using?
- Which ODBC driver are you using?

>Hi Daniel - thanks for replying - yeah that's what I am using but it returns no records... I have tried it on two separate PCs both with Window 2K and Office 2K... I have no idea what's happening...