querying dates?

[jlockley]

If I filter a membership table for < 12/31/05 I get about 500 records to view, all earlier than 12/31/05. > works as well.

Not so with a query. Querying for less than yields an empty table.
Querying for more than yields the following mix of dates (a sampling)

8/30/2000
2/27/2001
1/30/2001
2/28/2003
3/31/2004
2/28/2005
5/31/2001
12/31/2001
5/31/2004
5/31/2005

So what am I doing wrong here?

 

[jlockley]

and the answer seems to be that the query does not have a space. >12/1/2004 works. > 12/1/2004 works in filters but not in queries. Odd but logical where it doesn't work. I think