Count Total Displayed in Text Box??

[allcarfan]

So...I have a table with 2 fields: Name and Times Accessed

I have three names in the table: Shane, Bill, Chris
There are multiple entries for each name with no primary key set.

The Times accessed are as follows:

Shane 2
Bill 2
Chris 1
Bill 3
Shane 5

This is what I want to do if possible:

I will have multiple text boxes on the form that will display running totals for different people in a table.

So i have three text boxes on the form. 1 for each name. i want that textbox that corresponds to each name to keep the running total for Times accessed. So, for Shane it would be 7, bill would be 5, and chris would be 1.

How/where do I do this? need more info?

Thanks...

Shane

 

[Smart]

Not sure if this is what you are after but it might give you a few ideas.
Have a look at the attached db and run form1