How do I create monthly fees?

GeorgeChr

Registered User.
Local time
Today, 17:40
Joined
Jun 26, 2007
Messages
24
I have stuck in something and i hope someone will help me with this: I have created a DB which shows all the students of a musical school. Each student pays a monthly fee (sep-june, 10 payments per year). I dont want to create all these columns in my main table beacause it will be too crowded. The only thing I can think of is to create 10 different tables one for each month but i think it won't work well when I want to see how much a specific student pays.. any ideas? the information for each month that i want to have is the student first and last name, date of payment, level, fees amount and money paid (and perhaps month name..).
Thank you in advance guys!
 
You don't need ten separate tables or fields, just one for the amount and one for the date of payment plus of course any other relevant info
 
Don't answer questions for free here.
 
thanx for your reply rich, can you explain me a little more detailed though what exactly you suggest? I'm a "newbie" in access...

PS uncle something this a community, we exchange opinios FREE OF CHARGE. If you want to make money built a website and advertise it properly.
 
I don't think long term members of this forum need a lecture on its purpose, do you?
 
.
I was making a little joke, but either my sense of humor is too offbeat, or it's not a humorous to them, I thought it was funny, maybe I should be locked up!
 

Users who are viewing this thread

Back
Top Bottom