[RESOLVED w/ ADO .fields} Mistake somewhere in my loop???

[A441OTA]

Thank you everyone for the suggestions received... played with the code and ended up using .fields instead of a command (works faster too!!!)

With rs
.fields("name") = .fields("name") / .fields("name")
.update
etc.
etc.
end with

This works to calculate values in fields and put the answer into another field.



********************************
Good afternoon,

I am trying to calculate a value and put it into a field in an Access (2002) database via ADO and VB6. I had to create a loop to look at some fields first to determine if the calculation even needs to take place, then to figure out what field will be the basis for the calculation.

I got this same calculation to perform earlier but it was from one specific field and all the fields were numeric... these are not!

I cannot find my problem, however, I am new to this so goodness knows what silly thing I've done now. I have tried everything I can think of and am at my wits end, thus I'm begging (again!) for help from you wonderful gurus out here!!!!

I have attached a Word document that contains the specific code if anyone has a minute to look it over and offer any suggestions!!!

Thanks,
Mary

P.S. -- never mind, can't post Word....... converting to text......