Queries & Reports Help

[Jones Stanwell]

HI I am trying to create a database for players stats.
I have individual Tables set up for each player so you can view there stats individualy yet im trying to get t points for home games and points for away to add up and produce the total points for each player in a query and then to use that query to produce a report to show who is top of the stats with points. can anyone help

I have tried to attach the database but file to large I wold be willing to let you remote assistance to view it on my computer.

There are only a few forms created on the database at the momen so the data can be tested one this issue has been reolved would then be able to start using the database that I am trying to create.

I suspect that vba or sql code may be needed but I have not got a clue how to do the coding so could somone please help lol

 

[AC5FF]

First off --- I'm not an expert, but if I am reading things right you might be creating problems from the start.
You said you have a table set up for each player. I'm assuming something like:
Table Player 1
Game...Home/Away...Points
1..............H................3
2..............A................2
3..............A................4
etc...

I would think it would be better to set up ONE table for all players with columns as:
Player ...... Game ..... Home/Away ..... Points

With a table set up as this it would be easy to extract/sum/etc any of the data you need.

Just my 2cents worth..

 

[Jones Stanwell]

Thanks for that but what Im trying to do is this one table contains the an individual players stats ie team played socre won lost and points, I wanna create a query or i might need a relation ship for the query to work correctly to calculated the following how many they have one each and add the total points up i might be missing something so I have uploaded a copy of the database for you to view to see where i going wrong it is a scalled down version though