>SELECT sum(ph.b01_cash) from precap_history ph
And can you show us the connection code and how you retreive the recordset.
Try giving an alias to your field.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com