Totalling up fields in Access 2000 (1 Viewer)

[smilez]

Can anyone help me, when designing my database I came across a problem, I was trying to total up a text field so that I could work out the total number of people in the database. The Persons name can be repeated many times taking part in different events, I really need some help!!!

Smilez

 

[adz2013]

In the query group by person and then each person will only come up once. You have to use the totals button on the tool bar.

 

[Jack Cowley]

Create a Totals query and Group By the LastName (or whatever) and do a Count on LastName (or whatever).