Update Query question

[dekail]

Is it possible to do a transaction update using an update query on a field in a customer table to keep a running customer balance in the table?

 

[Haitham]

Clear More Please.

 

[mikey69]

This sort of thing is more safely done using Visual Basic and Data Access Objects. What I understand you to want is to read a record, update the field in the record and save it. I don't think this can be done reliably with an update query.

 

[dekail]

I got it figured out - all set