I don't think it would make a difference if you did the data selection in VFP or Crystal. If you do it in Crystal, the Fox ODBC driver or OLEDB provider will run the query. Of course, if you're using Fox2x tables, then you definately should do it in Fox.
>The request says that they would like the last six months usage (total if 6 months not possible) This is a foxpro database, with a field called dtuse and usage out of about fifty fields
>
>I think, I can either write a query in either foxpro or crystal.
>
>What are your suggestions?
>
>
>Thanks
>Jim
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer