How can I store more than 1 membership year joined by a member then be able to filter a how many people joined in a particular year?

Question

0.00/5 (No votes)

See more:

Hello, I am an Accountancy student but I need a membership database for a school project and I have no idea how to accumulate data of different years and so I thought of trying to filter it using a field for the year they joined.

The user will be asked to input their Student number name, contact details, and other basic information and also what school year the member had joined (example: 2016 - 2017) and it can store more than 1 of that data. Say for example a student has been a member for 3 years: School Year 2016 - 2017, 2017 - 2018, 2018 - 2019.

How can I be able to do this for a single person and do the codes necessary to view students joined at these particular years? I need to connect the query to visual basic.

Thank you so much for those who would help out!I've tried searching everywhere on the internet but nothing is helping...

What I have tried:

I tried to think of tables to create a query but I can't think of how I can do this. I was originally planning on autoincrementing (I don't know if this term is correct) a new table database for every new academic year that will start but apparently, it's too complex.

Posted 29-Nov-17 5:27am

Geneen

Updated 29-Nov-17 5:46am

ZurdoDev

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Accepted Answer · 2017-11-29T05:46:00

Quote:
a new table database for every new academic year that will start but apparently, it's too complex.

No, you would just store the year as a filed within a table.

Quote:
The user will be asked to input their Student number name, contact details, and other basic information and also what school year the member had joined (example: 2016 - 2017) and it can store more than 1 of that data.

You can create a table called students that stores this information.

Then you might want a separate table to record attendance. Something very simple though. For example store the student_id and the year. That way the student table only has the 1 record per student but if you want to get a list of what years they attended you would join to the attendance table.