Good morning.
I am developing a system in VFP based on COM.
I already built some COMs that access the data in my SQL Server.
These COMs represent a specific object in the database IE : the COM "Transactions" manage the "transactions" table. What I mean by manage, is that users can Add, Delete, Modify data.

Question :
As you probably know, managers live only for Stats !
Since the COM "Transactions" manage the transactions row by row (IE in a grid in a form), how could I use that COM in order to create statistics ?
Can I reuse that COM or do I have to build another one for Stats purpose ?
IE : Manager question : "How many trans between these dates ?".
The COM I build manage Transactions on a real time system IE : users modify data right now. But the manager is asking stats for Months ago !

Any ideas ?

André Deshaies
Fimat Derivatives Canada Inc.