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

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.

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