I have a field from which I make a selection from a value list which consists of 4 names.

What im trying to do is count how many records there are for each name.

EXAMPLE

If I had a hundred 15 records broken down as follows

John Doe = 3

David Atkinson = 5

John Smith = 6

David Smith = 1

I want to automatically displaly in a field that John Doe has 3 records, David Atkinson has 5 records and so forth.

I know what I need to do in my head, but I just can't get it to work in practice, and I have tried and tried.

Hope this makes sense.

You need two tables: your first one and then a second one which has one record per name (and related to the first by name). Define a summary count field for your first table and then put this field on the layout for the second table.

Thanks fella... I managed to sort it with your help.

Much appreciated.

Regards

Dave