>Hi all, i just need to create a index to show by client the invoices but keeping for each client their invoices in descending order, from the newest to the oldest. This index must be created on the table structure. Any ideas.?
>
>Thanks,
If it is for a report, I wouldn't create an index at all.
select [fieldlist] from [table];
order by Field1 asc, Field2 desc;
where [some condition];
into cursor Tmp
report form ...
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)