need to count similar items in one field

[Coyne]

I'm creating a database that will be used by an organization that will, among other things, be used for registering people for a symposium. They want to know how many people have registered in any given year. E.g., 2007, 2008, etc. So, I want to count the number of times 2007 has been entered in one field and next year when it's 2008 (in the same field) the count will have to be restarted.

To add a bit of compliation to this, spouses will not be counted, only members--but they will be entered into the same database. Thus there may be 200 entries for 2007, only 150 might be the ones to count.

I've looked through all of the forums and didn't find one that matched my needs, so either point me to what I missed or help!!

Thanks so much,

Coyne

[Ender]

Can you simply perform a Find for those records from 2007 that are not spouses? If you need the count to display in a field, you can use a Summary count field.

[Coyne]

Hi Ender,

I would like for them to show up in a field, but how do I set up a Summary count field to "just" recognize any given year. My earlier attempts ended up counting all of the records 2007, 2008, etc.

Thanks,

Coyne

[Vaughan]

Why not use a relational design? Create another table (Attendances) and create a related record each time a person attends. Put a year field on the record, then just count the records.

[Coyne]

Hi Vaughan,

I did try your approach first but I came up with the issue that if I have 100 for 2007 and then start with 2008, my numbers will go 101, 102, etc. Unless you figure out (and tell me) how to only count each year independantly.

Thanks,

Gary