defectivo Posted February 23, 2005 Share Posted February 23, 2005 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 Link to comment Share on other sites More sharing options...
Vaughan Posted February 23, 2005 Share Posted February 23, 2005 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. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6999 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now