Specifying multiple querry criteria in win 2000 vs win 98 1

[gouldish]

I have a simple querry that is suppose to filter the current months attendance. The crieteria command I use is Like "11/*/02" or Like "12/*/02". This works fine on Windows 98 machines but on windows ME ans 2000 machines it returns no records.
Is there a different way to specify criteria in these OS.

 

[FancyPrairie]

Haven't experienced this problem before. However, I don't store dates as text either. Rather I store them in a date/time format. Then, if I want to filter based on a date range I use the Between clause. For example,

Where (dteAttendance Between #11/1/2002# And #12/31/2002#)

 

[gouldish]

i store them as dates also but I forgot about that string. Thanks, it worked.