calculation query

[munday63]

I am creating a football dream team database with two tables:

Team table - Team ID, Team Name, Player 1, Player 2, Player 3, Player 4, Player 5, Player 6, Player 7, Player 8, Player 9, Player 10 and Player 11.

All the player columns are lookup functions which are linked to player table

players table - Player ID, PLayer Name, Position, Club, Value, Points

My problem is i cannot figure out how to use a query to calculate the points total from inputting the points into the player table.

I have came close with a query, but it only adds the player IDs together not player points. Also, it adds all the teams together in one box, not seperate teams in sepeare rows on the query.

 

[Mile-O]

I am creating a football dream team database with two tables:

Team table - Team ID, Team Name, Player 1, Player 2, Player 3, Player 4, Player 5, Player 6, Player 7, Player 8, Player 9, Player 10 and Player 11.

I've told you in your other thread to look up normalisation - understanding this will help you get away from your current use of Access. You are using it as if you are using Excel which is not the way Access should be used.

 

[munday63]

can you explain how to use normalisation in relation to my project?

 

[Mile-O]

You'd be better off reading about normalisation and then asking questions about what you don't understand.

 

[munday63]

i have trtiede reading about it in one of my school books but i cant relate it to my project. Its so frustrating

 

[munday63]

Can my project be done though?

 

[Mile-O]

Okay, start by listing all the different objects that will be in your database (i.e. players, teams, matches)

List everything here that you think should have its own set of attributes.

 

[munday63]

in my database, i will be having player data which includes an ID, their Name, their position, club, value and their points which will be updated weekly.

i will also have teams which are selected by choosing eleven players.