having an autoupdate field in a Access 2000 table

[Netooi]

Is it possible to have a field that autoupdates itself based on another field in the table...
For example

tdate accountname number
10/10/2000 as 1
12/02/2001 as 2
12/02/2001 shailesh 1
12/03/2001 as 3
12/03/2001 shailesh 2


I want the number field to autoupdate itself based on accountname and the number of that specific accountname in the table.

Thanks for your help
Netooi

 

[Trendsetter]

Is it just a count of the number of entries against an account name? If this is so then it would not be good practice to store this information in a table as it really is calculated data and should maintained on the fly.

Consider what would happen if you deleted the entry for 12/02/2001 account as...........