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
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