You could create a view based on the table's fields plus calculated values, create indices in code on the view and make the Grid.RecordSource=myview. This way it would still be fast and eliminate data redundancy. HTH

>It is redundant.....
>
>But it is FAST !!!!.
>
>All selections etc can be done on the calculated field.
>even a search on amount would be possible.....
>Sorted on amound etc etc etc