>convert (dtype, sum(AMOUNT))
That's a T-SQL function. I think he was looking for a VFP way. If you do this in VFP, you get the VFP3 migration tool.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao