Sergy,

I've got 9, but this program has grown so large over the years, I'm a little afraid of breaking something. I developed it initially about 12 years ago, I think, in fpw2.6.

I included FoxFire 3.0+ for reporting and the users have become totally dependent on it. They've probably got over 100 different active reports, continually deleting old ones and creating new. It continues to work well, except in the latest problem I've had in calculating averages.

The formula you gave me worked, as far as the query is concerned, but since then I've noticed that FoxFire doesn't seem to like nulls. I'm getting "*" where I should be getting 0.50 and "1" where I should be getting 20.50 (0.50 and 20.50 are representative numbers for two colums).

Everything I try in FoxFire works okay from the Command Window. I also created a "test" custom report and it works okay. I hate the thought of going back to designing custom reports:(

I still might upgrade it to 9.0 and FoxFire 8.0

Thanks again for your help.

Dale


>Hi Dale,
>
>It would be quite easy to acomplish in VFP9 for any data type with new CAST() function.
>
>>Thanks! This works just the way I want.