Hi all,

I have a table with 7 fields, 2 of which contain $ values. I want to delete all records, where both fields containing dollar values = $0.00. I am using ADO in VB6. Can anyone help me or supply me with some sample code that will do this?

I thought it might invlove a query...
Delete * from ... Where .... And .... =$0.00
but am unsure how to do this.

Cheers