senority list to sort

[scopes456]

I have a student database where they can sign up for clubs. Each club has 10 slots, and each student has four options to sign up for different clubs. Attached to each student record is their age. I would like to use their age (oldest to youngest) to list them for a club. Since each club has limited space, when a student did not make the cut in one club, but has another, using his age to place him accordingly on that list.

Basicly i want to make a seniority list to place the student accordingly. Is this possible?

Thank You

 

[spikepl]

Yes it is.

FYI: "Is it possible?" questions can get you a bitchy response like above.Simply because it is like asking "Is it possible to make a million"?

When asking, ask for specific issues, and show what you've done so far and what you are stuck on.

As to your students, you do not store an age because that changes by the second, but you store the date of birth and calculate the age whenever needed.

 

[scopes456]

Spikepl - you are right, i should get to the point and indicate where am getting stuck.

One the student record there is date of birth so i will use that instead of age.When a student bid i can see their names on the clubs they want, but since its limited on space (10 students per club), i want it, so if the student does get there first choice it will move their name to the second choice. using date of birth to list them.