starting database problem

[pascal]

I like to make a database of football results and tables (standings), but I'm not quite sure how to start on it. First of all I need of course a table in which to store the results of the matches. But do I need to make a table for the standings (tables) or don't I, because this is something that I want to be calculated out of the results of the matches played? These are the items I want in my standings: "Matches played", "Won", "Lost"; "Draw", "Goals", "Goals against" and "Points". Now, how can this be calculated out of the results automatically. Do I need the use of arrays he or what? I've thought over a lot already but can't find out how to do this. Can someone help me out with this one or has someone got a database of this kind.

Thanking you in advance.

 

[Mile-O]

I like to make a database of football results and tables (standings), but I'm not quite sure how to start on it. First of all I need of course a table in which to store the results of the matches. But do I need to make a table for the standings (tables) or don't I, because this is something that I want to be calculated out of the results of the matches played? These are the items I want in my standings: "Matches played", "Won", "Lost"; "Draw", "Goals", "Goals against" and "Points". Now, how can this be calculated out of the results automatically. Do I need the use of arrays he or what? I've thought over a lot already but can't find out how to do this. Can someone help me out with this one or has someone got a database of this kind.

Thanking you in advance.

How deep are you wanting to go with respect to the football teams? Players and teams, obviously, but what about leagues?

Also, you won't need to store points in your table as you can calculate that from a query by making a field like this: Points: (([Wins] * 3) + ([Draws] * 1))

 

[Tiro Cupidus]

You can calculate your standings in a report. If you're doing this for only one team, I think you would need only one results table.

 

[pascal]

Already thanks for the quick replies, but I really think this can't be done with a simple query because what I want is that all the items of the standings must be calculated for each team. When I enter a new match result the standing must be recalculated and of course be sorted. Let's say we've got a competition of four teams (Belgium, England, France, Spain) and I have a form on which to fill in the results of the matches. After filling in a match result I want to see immediately the changes in the standings. For example:

match results

Belgium - France 1 - 0
England - Spain 3 - 1

standings (This is what I want to be calculated and want to see for example on a subform of this form)

1. England 1 1 0 0 3 - 1 3
2. Belgium 1 1 0 0 1 - 0 3
3. France 1 0 1 0 0 - 1 0
4. Spain 1 0 1 0 1 - 3 0


Thanks again.

 

[Rich]

Look up Ranking in queries, and use calculated fields as Mile' suggests