>Thanks Nick. That worked... here's another problem I've encountered today.
>
>I'm trying to order some records based on times. But the "order by" command ignores the p.m. or a.m. part of my time. i.e. 1:32 p.m. comes before 6:00 a.m. Is there a way around this?

PMFJI, but it sounds like you store the return value of TIME() which is a character string. If you also store the underlying Datetime() value, you could sort on that.