Hjælp til at komme videre med Access database

Its important that you get the table design i order first. Dont make any forms/reports until you have done this.
Make a note of all the information you want to be able to enter into the database and also what you want to be able to see in your forms/reports etc. These are the basis of your tables/fields.

Which tables/fields do you currently have?

Im building on a template from Microsoft (Music Databse) and it contains a table for artists and recordings. The templete database is made for albums, but i will use it as a reference when i will start to build up my own datase, and was just wondering how the request to have music charts included could be done.

Mikael

"... was just wondering how the request to have music charts included could be done."

Well this all depends on where the information for this comes from.

If each titel in the Template database has a unique ID then
I would think all that you would need is an extra table which contains a field for the ID of the Title and a field containing a date. This date is the first day of the week (Monday). And also a field for entering a number (1 to 20) which contains the position that ID had for that date (week)

Then in a form you could choose the date at the top of the form. and then choose the titles and its position in the lower part of the form. The date gets coppied from the top into each record you add.

This information should then enable you to find all records for a specific week and also find all weeks a specific title was in the top 20.