Query Problem Displaying Values over 10

[zoup]

I have times that are converted using a hoursandminutes function.

Times range from HH:MM to D:HH:MM. But it has a problem correctly displaying times that might be 1:00 and 10:00. I want to criteria >"5:00"

Any reason why 10:00 would not show up in this criteria?

Any help greatly appreciated.

 

[The_Doc_Man]

When comparing times or integers or floating, 5 < 10

When comparing strings, "5" > "10" - because string compares run from left to right character by character and the first inequality defines the sense of the comparison.