Hello
i am making a football player database and was wondering what the best way to uniquely identify each player. I was thinking the first three letters of the surname and first two of first name but there is always the chance of two players being the same. Is the only way to use numbers...
Hi everyone
i am planning to start a aussie rules(sport) database and want to include player stats. My problem is how to include the player statistics. I was thinking of setting one table as the player details like first name, last name, middle name, playerid and another as playerid, season...
hello
can someone help me with this query. I want to get the averages of a football team's average kicks handballs and marks and group it by the away team. I am able to get the averages of a team as a whole but am stuck on the away team. I have two tables the game and stats. The game is as...
Hello everyone
i am creating a sports database and the games can take place at day or night. Do you think that using a true/false statement or creating another table for day/night would be better?
Thanks for your input
i tried what you said with auto_increment but it gives error. This is how i entered it.
insert into game table values (
,'2003-3-28','1','61058','col','ric','mcg','-17.5','17.5');
The first number is meant to be the auto increment(ie the on before 2003-3-28).
Thanks
hello everyone,
whenever i insert data into my decimal column the value is different from what i wanted. like when i enter -17.5 the value goes in entered as -9. My decimal type is entered as (1,0). I just want it to be one decimal place and to betered in as what i want.
Also i was wondering how...
i copied your sql into access and i got this message
"you tried to execute a query that does not include the specified expression 'team' as part of an aggregate function"
what does that mean?
thanks jonfer. wow this sql language is quite powerful. the sql works and it works well but i would rather have two queries for home and away where all the teams are shown.
cheers mate
sorry it has taken so long to reply.i'm trying to get averages for separate home and away games per team. I want to get the averages for teams when playing at home, then all games away and another query of all games combined to see the differences when the teams play at home and away.
This is what the outcome should be. This is the outcome of my home averages query.
Team AvgOfFG% AvgOf3PT% AvgOfFT% AvgOfOffReb AvgOfDefReb AvgOfTot
Victoria Giants 46.86 36.30 74.43 13.45 26.25 39.70
Townsville Crocodiles 46.5652435544365 35.22 78.6254488212333 14.85 27.15 42
Perth Wildcats...
i already have game joined to team twice. As i'm not too confident with sql, i'm using design view and have been able to make the home team averages query successfully and would not think it would be possible to join an home and away averages query together. If joining home and away to team is...
Hi everyone
I'm a newbie to access and i've been stumped on this query for a while now. The query reads as this
SELECT Teams.Team, Avg([Game Percentages].[FG%]) AS [AvgOfFG%], Avg([Game Percentages].[3PT%]) AS [AvgOf3PT%], Avg([Game Percentages].[FT%]) AS [AvgOfFT%], Avg([Game...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.