Search results

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

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

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.

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

Hey everyone. Can someone give me directions on primary keys and foreign keys for my tables. This is my first ever database and pretty clueless on what to do. It's to keep track of the nba scores. I don't even know if the tables are right. The tables are as follows Date Team Score Line...

Hello everyone, this is my very first post. I am new to databases and was wondering if my idea has database potential. I want to do a database on basketball with all the scores and statistics. But as sports score read like 120-98, is it possible to do this or do i have to have 1 column reading...