Access bug???

[J-F]

Is this a known problem?
I have a table which includes some times (00:22:22 etc). When I do a query asking for all times <#00:22:22#, 00:22:22 always shows up. If I do the same query using a lower time, it returns the correct results.
Whats going on.
What I'm trying to do is get someones placing in a race from their times. The result + 1 should be their time which works fine, as long as their time is less than 00:22:22

 

[araskas]

No. It gave me correct results. I created a temp table with a Date/Time field formatted as hh:nn:ss.
Then i ran this query-
SELECT Table1.ID, Table1.Time
FROM Table1
WHERE (((Table1.Time)<#12:22:22 AM#))
ORDER BY Table1.Time;
Access changed the criteria I entered i.e 00:22:22 to 12:22:22
And it returned correct results.

 

[Rich]

How is you Times field formatted?