Thanks Kurt for your response. Yes this is a sale and inventory application so I can do as you suggested, because I will need it for comparative reporting purposes.

Thanks and regards.
Bhavbhuti

--- In firebird-support@yahoogroups.com, Kurt Federspiel <federonline@...> wrote:
> If it is inventory or sales, you can keep an aggregate of sales over a week, month. or quarter for everything over one year. For timestamped data, this is much easier, but your inventory should be manageable this way.