VFP 5.0 SP3/Win 95/NT Network
I have a transactional table with an EventDate column defined as DateTime and some informational columns. There is regular index defined on the EventDate column.

I have a report where the user specifies a first and last date. I filter using
"SET FILTER TO BETWEEN(TTOD(EVENTDATE),LLODATE,LHIDATE)".

There are 2 events at the top of the file with the same datetime. The report will show these both sometimes but page-down, page-back will make the first one disappear. My guess is that the index is not distinguishing between these rows.

Any help in making this more consistant will be greatly appreciated. Thanks
-Swen