Querying dates fails

[Alan Júlio]

Hi folks,

I have an access database where there is a field with date format dd/mm/yyyy hh:mm:ss

So, when I try to get data using sql comparasion statements the data comes incomplete. For example (x and time are two of the fields of mTable):

"SELECT time, x FROM " & mTable & " WHERE time > #18/12/2009 00:00:00#"

returns only one register, but should be five.

Is the sintax correct? How can handle this database more efficiently?

Many thanks!

[RolfJ]

This may not be of much help, but I checked the syntax and it appears fine to me. Could you post the five registers you expect to get returned by your query? Maybe there's something fishy about them.

[stanl]

myabe >= rather than just > .02 Stan