Recent content by MrBLT

Hello everyone for one of my tables i have a event that can happen at day or night. What is the best way to enter this data. Should i use a true/false statement or just enter it as is? Thanks everyone

Hi everyone 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 Percentages].OffReb) AS AvgOfOffReb...

hello all i just recently completed my tables through the help of the tables forum and now posting my first query problem. I am working on a basketball database and have the following tables game gameid(pk) hometeam awayteam date venueid homeline(gambling term) awayline score gameid periodid...

thanks for your help Pat. Does this look right now. However i'm still having trouble with the team table. When i expand a team for more details it shows the fields of the game table except for the home team. It also doesn't display any information either. Is this a problem or am i worrying over...

sorry i sent the wrong attachment

does my relations look right or do i have some more work to do. i found that in my teams table when you expand it it shows the games table but it shows all fields except the home team. And also when there was an away game the expanded teams table did not show the data. Thanks again

thanks neileg may i ask what would be my primary key for the score and stats table then

hello everyone i've been working on my basketball database for a couple of months now. i'm pretty sure i've got the tables right. Just a few things before i tell you my tables. This is just a pet project and it is based our the nbl(national league) and i'm just concentrating on the team stats...

so basically i have the game info in the 1st table gameid date home away venueid homeATS awayATS i home team scores in the 2nd table gameid 1stqtr 2ndqtr 3rdqtr 4thqtr when i try to enter the away team scores in the same table using the same gameid, it tell me that there is an...

sorry about that my table structure are as follows gameid date home away venueid homeATS awayATS gameid 1stqtr 2ndqtr 3rdqtr 4thqtr gameid teamid fgm fga 3ptm 3pta ftm fta reb foul assist block steal turnover teamid team venueid venue this is my first database. it may be that my tables...

I'm trying to make a basketball database and i was going to enter each team in seperately. However whenever i enter a new team in say my score table, there is an error saying that it would create duplicate errors in the index, primary key or relationship. Why is this happening, or how can i get...

Can someone tell me if there is any problems with using access with php and why mysql is the best to use with php.

Thanks namliam Thanks hockeynut. do you follow some form of hockey I am only going to the team level of statistics as it would be to time consuming to enter player statistics. do you guys follow sports of any kind.

Can someone tell me if i'm on the right track. After doing some reading on Access, this is what i have come up with. This is a basketball database that i will transfer to put onto a website. GameID(pk) TeamID Venue ATS GameID TeamID 1st qtr score 2nd qtr score 3rd qtr score 4th qtr score...

Thank You for your reply Pat. You have given me some ideas. Has anyone on this forum built a sports database or know anywhere i can go for more help. If it helps i'm trying to create a database so i can put it on a website as like this site http://www.covers.com/data/nfl/game/g1_10200.html...