Baseball Scores

Aug 22, 2006

Hello All,

Trying to make a softball database. Have the tables as:
tblPlayers
tblGames
tblTeams
tblTeam_Players
tblStats

Anyays, having problems with making a games win/lose querry. In my tblGame I have the following

GameID
Date
Time
HomeTeam
AwayTeam
HomeScore
AwayScore

What I am trying to do is write a querry that will give me the win lose record of all the teams.

Problem is I can get the total for Home and totals for away, but not both at the same time.

What I am looking for is something like:

Team wins loses
Cleveland 15 1
New York 10 6
Altanta 5 10
Chicago 6 9

etc...


I am an experienced in access but limited on SQL.

Any help?

Thanks

View Replies


ADVERTISEMENT

Table Design Question -- Baseball Related

Jul 15, 2005

Hello,

I'm not sure why I'm drawing a blank but I am. Could I please get a few suggestions on how you might organize these fields into tables?

These are not baseball stats fields. I'm keeping track of how often teams win over the years. I would like to do generate a team webpages showing all historical wins, losses and championships.

TeamID
TeamName
Year
Wins
Losses
AL_DivisionChampion (3 divisions in each league EAST,WEST, CENTRAL)
NL_DivisionChampion (3 divisions in each league EAST,WEST, CENTRAL)
AL_WildcardChampion
NL_WildcardChampion
ALCS_Champion
NLCS_Champion
WorldSeriesChampion

Initially I thought about YES/NO fields but there are so many variables. I need to know STL won the division but also that it was the NL Central.

Any help would be greatly appreciated.

Thanks
Rob

View 7 Replies View Related

How To Average Scores

Mar 9, 2008

First of all I consider myself to have Intermediate knowledge of Access. I am comfortable building tables, queries, reports, macros, etc. but get a little lost when needing to manually code something in a query.

I need to create a database to document quality reviews of certain reports the plant creates. Typically each report gets reviewed by 2 to 6 people and each section is scored. So lets say the database table has the following fields

Report_No
Reviewer_Name
Review_Date
Section1_Score
Section2_Score
Section3_Score
Total_Score

I need a query that will average each of the Section Scores and Total Score so I can build a monthly report showing the report and the average grade for each section and the average total grade.

Any suggestions on how to do this is appreciated.

Thanks,
Jim

View 1 Replies View Related

Creating Database For Test Scores

Jun 16, 2015

I am looking to create a database that collects data from past tests, predict probable future score, and compare to goal score. Currently I am studying for the Bar Exam and want to track (in all 7 subjects):

-my current scores for practice exams
-prediction of what my score will be on exam day
-comparison of actual and goal score
-comparison of predictive and goal score
-all of the above, separated by different types of Tests for each subject

Below is an example of the type of data :

Ex: Civil Procedure--06/15/15-Kaplan questions-> 6/10 (60% practice score)-> (predict gain 1 point 70%)-> (actual exam goal 20/28=71%)
Civil Procedure --06/15/15--past MBE questions->7/10 (70% practice score)->(predict gain 1 point 80%)-> (actual exam goal 20/28=71%)

Also from this data I want to generate graphs

Would this be possible in Access? Should I use excel instead?

View 5 Replies View Related

Student Scores Display In Multiple Columns?

May 9, 2015

how can I display the scores of a student in horizontal?

I have two tables, one with students information and another for students' score.When I query may table using this

Code:

SELECT Student.StudentName, WrittenScores.Score
FROM Student INNER JOIN WrittenScores ON Student.[ID] = WrittenScores.[StudentID];

It resulted to this

All I want to do is something like this

View 14 Replies View Related

Queries :: TOP N Subquery (Scores) For Each Member In Race League

Jan 5, 2014

I have a race league, I want to select the top 10 point scores for each member.

I have read the Allen Browne article (and many others) and tried many variations on his code but cannot get this working.

I face two issues
- The ORDER by clause has no effect, points are not sorted with largest first
- Access being unable to differentiate between scores with the same value and returning additional records. I have added an "Event" field to make the record unique, but this does not seem to work.

Query code is

SELECT qLeague.Member, qLeague.Event, qLeague.Points
FROM qLeague
WHERE qLeague.Points IN
(SELECT TOP 10 Points
FROM qLeague AS Dupe
WHERE Dupe.Points= qLeague.Points
ORDER BY Dupe.Member, Dupe.Points DESC
)
ORDER BY qLeague.Member ASC, qLeague.Points;

This returns more than 10 results per member:

Member Event Points
Alex Peters SDMC North Weald Sprint 3
Alex Peters HCAAC Debden May 3
Alex Peters GB/Harrow TAMS NW Sprint 4
Alex Peters HCAAC Debden Sprint 5
Alex Peters Llys y Fran Hillclimb 6

etc ....

View 10 Replies View Related

Generating Scores Based On Number Of Tick Boxes?

May 3, 2012

I am wondering if it is possible to calculate scores automatically based on the number of tick boxes the users have selected? If yes, how do I go about doing this feature?

View 5 Replies View Related

Risk Assessment Database - "rollup Risk Scores" From Workstation To Department...

Jan 3, 2008

I don't know if it'll make sense out of context like that.

I am working on a Risk Assessment database, where a factory can be assessed to see which risks exist at workstations/departments or the whole facility.

So Assessments can be either a Workstation, a Department or a Site level.

Within each assessment there are multiple risks, each of which receives a numeric "score" (assigned by assessors). Let's say that it's 1-100 scale.

I need a way to "roll up" (or summarize) the scores, so that the whole assessment can display a "total" risk score. But it's not just adding up of the individuals - there are "weighting" multipliers we use, because we want to emphasize high risks.

Also, multiple workstations' rollup Score needs to "roll up" to their department, so that a department's score is "made up" of individual workstation scores. Also using the same weighting multipliers.

Then, the departments are rolled up to the whole facility.

The database has a table of the weighting multipliers so if a Risk Score is 75 or higher, it's to be multiplied by 10, 50-75 - multiply by 8 and so forth.

I can't come up with a way to do this through queries or code.

thanks!

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved