count field VALUE repetitions??

[defectivo]

Hi everyone,

I think this is the right category -- I'm new to this whole thing and really need to create a database. I will be organizing a career day at my scool and students have a choice of 4 sessions that they can attend (i have made 4 fields -- session 1, session 2, session 3, and session 4). For each of the sessions, I must be able to determine how many times the SAME Value (i.e. Careers in Medicine) is repeated. This would be used to determine the amount of people attending each session. Is this something that could be done?

Thanks so very much for all your help guys

[Vaughan]

This is a text-book case for a relational design. Two files (tables) are needed: Students, and Session.

In the Sessions file, each record represents one student attending one session. Getting the data out will be easy with a summary report.