Hi Naomi & Sergey,

I did get rid of the problem by eliminating the time string from the index (I mentioned this at the start)

And yes, Sergey, I do realize that your suggestion is settings independent and therefore preferable.

My point was (and is) that, irrespective of correct or incorrect results of the time string component, why was I getting the phantom record?
The 1st 3 parts of the index expression created a unique index, the time component only added a more chronological view to the records. Even if it returned something other than intended, it would, at the most, display the records in a slightly incorrect order.

I am still trying to figure out what causes the phantom record condition...


>>Hi Naomi,
>>
>>Thanks - Sergey did point that out earlier.
>>I was really trying to figure out the reason behind the phantom record, more than how to incorporate the time into an index expression.
>>(If I know the root cause, I can avoid the pitfall in the future)
>>
>
>Ashley,
>
>Do you still have Phantom records after you have corrected the index problem (e.g. used ttoc(start,1)) in your index expression?