Hello everyone,

I have a database with the following fields:

Name
Control #
Balance
Date Posted
and more fields

What I need to do is to write a query(ies) that will group the records by
control number and pick the record within each group that has the most
recent Date Posted and zero out the balance in all the other records and
keep the balance unchanged in the record with the most recent Date Posted.

Is this possible easily?

Any help would be greatly appreciated!!