Count the Riders

[Atamagaokashii]

Hello, I'm trying to create a table that will count the amount of times a certain amount of text appears.

Making it easier:

I have two tables:
Riders and Teams

The Riders table has a Team Name field which is Text.
The Teams table has a Riders field which is Number.

I want the Number field to count how many times Team Roberts appears in the Riders table and automatically enter the number itself.

How can I do this?

 

[odin1701]

Create a totals query.

Put the Team Name field twice. In one, for the Totals option do a Group By and in the other do a Count.

That will show you the Team Name once, along with the count of how many times it appears.

Why would you want to store this information?

 

[Atamagaokashii]

It's part of a project I'm doing.

How do I "Group By" and "Count"?
I'm fairly new to access ... And I'm using Access 2003.

 

[odin1701]

You shouldn't store that information. You can get it through a query, which will always be up to date, no matter what changes are made to the main table. Storing that information is redundant because it is already stored.

Do a search for access totals query on Google, I am sure you will find some articles which show you how to make a totals query. Or look it up in the Access help file.