How do I create monthly fees?

[GeorgeChr]

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!

 

[Rich]

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

 

[Uncle Gizmo]

Don't answer questions for free here.

 

[Rich]

Don't answer questions for free here.

Is there something we shoud all know here?

 

[GeorgeChr]

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.

 

[Rich]

I don't think long term members of this forum need a lecture on its purpose, do you?

 

[Uncle Gizmo]

.
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!