Search results for query: *

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

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...

hello how do i set the primary key if i did not do it when i created the table initially? Thanks

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...