>>I wonder if a DTOC() would help?
>>>
>>
>>Wait, that wouldn't work...you lose the minutes and seconds that way, don't you?
>
>End of day mind lapse -- see my reply to myself where I replaced that with TTOC(). That's more out of curiosity. That more than doubles the field size, I believe, and is more expensive in indexing.
>
>Jay
hehe...all of this to get a primary key. Pretty stinkin funny!! BTW, in case you didn't get cc'd, Jonathan came up with the way to do it w/o duplication.
Steve Gibson