Hi Stephen,
Use a compound index.
For example, if the deptid is an integer, use the index expression
STR(DEPTID, 10) + DTOS(TRANSDATE)
Cheers,
Andrew
>I have a table that I index on a department identifier. Then department id has several records that are dated. How do I sort the indexed table by dates wiyhin that index? Thanks for the help.
If we were to introduce Visual FoxBase+, would we be able to work from the dotNet Prompt?
From Top 22 Developer Responses to defects in Software
2. "It’s not a bug, it’s a feature."
1. "I thought I fixed that."
All my FoxTalk and other articles are available on my
web site.
Unless specifically identified otherwise, anthing posted here is purely my opinion and may or may not reflect the policies or practices of Microsoft.