Football League Table From Fixtures Table
Feb 10, 2008
Hi i am wandering if anyone can help me complete this problem:
i have a table full of fixtures/results in the following form:
tblFixtures
fixtureID*
compID
fixDate
fixTime
HomeTeamID
AwayTeamID
HomeScore
AwayScore
PitchID
RefereeID
is it possible to create a league table on those results.
1. There is more than one competition in the table so it would have to be by compID
2. There is fixtures without results so they would have to be excluded as well.
Any help?
View Replies
ADVERTISEMENT
Nov 7, 2005
I am trying to build a database for a local football team, and am having trouble with the design of the tables. The database contains numerous tables but my main problem is that within the database there are 4 types of people information:
Players:
(a player can have more than 1 guardian attached, eg mother, father, uncle, etc
A player could also be a member of staff eg coach)
Guradians of the players
(a guardian can be attached to more than 1 player, eg two sons playing for the same club
a guardian could be a member of staff, eg manager).
Staff Members
(A staff member can also be a guardian)
Doctors
(a doctor could be a staff member and also a guardian).
What is the best way to approach the design of these tables as i dont want to have to enter the same name, address details etc, more than once for if a person is in more then one of the people information categories.
The main focus of the database is driven by the player Information.
I want to show what guardians are responsible for each player, who the players doctor is, etc.
View 9 Replies
View Related
Sep 5, 2013
I have created a database that records the scores of each player etc and puts them in league table like structure.
Within this database which I would like to extend I would like to know if its possible to have a query to calculate a league table for the teams if home team overal score is greater than away team home team get 2 points for win 1 for draw no points of loss and same if away team won.I also want to be able to change it to a web database and add club address details like contact list to it.
View 1 Replies
View Related
Jan 18, 2007
Hi, first of all sorry if I posted this in the wrong section, but I think I'm ok!
Secondly, I don't have much knowledge in access, so anything may help me ;)
I want to create a football spreadsheet something like this one:
http://www.databasedev.co.uk/user_interface_3.html
It doesnt need to be too similar, but it needs to have somewhere for the user to put in results of matches - like on the form on that one.
All I have so far is two tables - one for team names and one for player names.
Do I need to make a form as a place where results can be put into the database?
Also, I need to create a league table, based on the results. 3 points for a win, 1 for a draw (real football rules) but I don't know how to make the table. Would it be a table, a query, a report? I'm clueless on that part really ;) So any help would be good.
Any help on the relationships I need would also be great
View 7 Replies
View Related
Aug 9, 2007
Hi everyone, im new to this forum as well as MS Access. Over the past week or so Ive been reading through a lot of tutorials and watched a few videos on how to master Access. I've learned a handful of things, however its not enough, so i need some help.
Im trying to create a simple database for our local community football/soccer league. It's nothing fancy, just simple information to keep things tidy and organised.
The main features include Keeping a track of all results and outputting an up-to-date league standings, so it can be printed and available for everyone to see.
Few details: in soccer, there are 3 possibile outcomes of a match (win,draw,lose). Each win earns a team 3 points, draw 1, lose 0. Of course, the standings table will be sorted by the amount of total points each team has uptodate (descending order). Oh, and the goals scored - goals conceded should also be summed up for each team and displayed.
In theory, it sounded easy to me, but when i actually started doing it, i got stuck right at the beginning... :confused: So, here's what i got so far:
tblResults table that collects the following information: Date, TeamAName, TeamBName, TeamAGoals, TeamBGoals (the last two collect how many goals team a and b scored)
...well, thats pretty much it... lol :o
I've been experimenting with queries for a while but feel without some help i wont get it sorted...
Would appreciate if anyone could point me in the right direction... :)
View 7 Replies
View Related
Nov 30, 2005
For a couple of years now I have been keeping a spreadsheet record of UK football match results and statistics - I use this as the basis for gambling on future matches. I now want to migrate this information into a database so that
1) It is much easier to enter the new data(via picklists)
2) I can generate reports on particular teams to help me on future betting decisions
Being almost completely new to Access I am struggling with the design. The information I'm capturing is:
Match Date
Competition(table including five)
Home team/away team(table including many depending on competition)
Home formation/away formation(table with standard list)
Home goals/away goals(numerical)
Home corners/away corners(numerical)
Home bookings/away bookings(Numerical)
Referee(from a standard list)
All the above is in a match results records table with relationships to each data element table.
For the form for data entry, I want pick lists for all non-numerical values - eg team, formation etc. I would like to get a little cleverer and for the team pick list to only contain teams that are in the competition I've selected(eg Uk or European).
I've created some tables and relationships, but when I create a simple form with combo-list boxes, the list itself comes up blank even though I've linked the field to a particular table of options(eg a competitions table).
Can anyone help on suggestions for the overall design(should I have separate match results tables and team tables for each competition?) and with this particular combo-box problem please?
View 3 Replies
View Related
Sep 26, 2005
Hi there.
I am trying to create an append query that will update employee time cards for holiday hours without having to enter each time card individually.
* I have an employee table which has the employee id, first name, last name and so on.
* I have a timecard table which holds the employee id, date and time card ID.
* I have a time card hours table which holds the time card detail ID, time card id, work order id, job code id, reg hours, ot hours, holiday hours, etc
* I have a time card expense table which holds the time card expense id, time card id, work order id, inventory item id, cost, total, etc
I need to create a form with a multiselect list containing a list of the employees and a box for the date and for holiday hours. I need to be able to select the employees, enter the date, enter the holiday hours and append it to the time card table AND the time card hours table.
For example I need to append and create new records from the form: the employee id (from the multi-select combo list) and date (txtDate) would pass to the time card table and the holiday hours (txtHours) needs to pass to the time card hours table.
I cannot for the life of me figure this out...it doesn't seem like it should be too hard.
Can anyone help?
View 3 Replies
View Related
Jan 10, 2005
Hi does anyone know of a system out there in MS Access that can do what this program does in word. i have been using this word version but i wanted to keep a history of records...
I use this for Badminton and not squash, so if anyone wants a game i am happy to play
anyway have a look and let me know how hard this would be to achieve.
cheers
Andy
View 4 Replies
View Related
Nov 22, 2006
Hi,
I am trying to create an Access system for a 5 a-side football company. They have both League Fixtures and private bookings.
The aim of the system is to allow for input of new teams, referees and fixtures and also for private bookings.
Im really struggling with this one.
I have had a go at designing it in Access but the forms wont work.
I wanted the system to have the following fields:
TBL_Booking
Booking ID
Pitch Number
Date
Time
Fixture ID
Customer ID
(Only one of the last two fields will be filled in one being for a league fixture and one for a private booking)
TBL_Fixture
Fixture ID
Referee ID
Team1 ID
Team2 ID
TBL_Customer
Customer ID
Customer Name
Contact Number
TBL_Team
Team ID
Name
Manager ID
TBL_Manager
Manager ID
Name
Contatc Number
TBL_Referee
Referee ID
Name
Contact No.
Hope somebody can help.
Jim
View 1 Replies
View Related
Jun 3, 2005
I've been asked to collate some information based on a kid league, I am trying to sort out how precisely it works
the data I have is this
finish position, name, club
I need to calculate the best kiddie based on 3 of a possible 6 races
So tbls
tblResults
fldSeries
NAME
CLUB
Pos(isition)
tblScores
fldID
pos
Points
query1
SELECT tblResults.fldSeries, tblResults.NAME, tblResults.CLUB, Sum(fldScore.Points) AS SumOfPoints
FROM tblResults LEFT JOIN fldScore ON tblResults.Pos = fldScore.Pos
GROUP BY tblResults.fldSeries, tblResults.NAME, tblResults.CLUB, tblResults.Pos
HAVING (((tblResults.fldSeries)="220-2005") AND ((tblResults.Pos)<51))
ORDER BY Sum(fldScore.Points) DESC;
I need this to be changed to only pick up athletes with only the best three scores?
any hints?
STuart
View 3 Replies
View Related
Jul 21, 2005
I have a lot of help on some reports but I keep running into a problem when dealing with ranges.
A football field is 100 yards long. It is broken into field zones by yard lines.
For example, -1 to -10, -11 to -25, -26 to -49, 50 to 26, 25 to 11, 10 to 1.
I am trying to find some percentages for those field zones.
I know you can create an IIf statement that could give it another value, but how can I create a query asking for all plays or values when the field position lies within a certain range (ie. from the -1 to -10)?
If anyone has any ideas, I would appreciate it. I am a novice Access user and we are trying to use Access for our recruiting database and our Scouting database.
Thanks in advance.
-Mike
maldrich67@yahoo.com
View 10 Replies
View Related
Feb 18, 2005
Hi Everyone
Firstly I'd just like to say HHHHHHEEEEEEEEELLLLPPPPPPPPPPP!!!!!!!!!!!! LOL
I'm creating a fantasy football database for a skool project but have hit somewhat of a stumbbling block with the way to display the team. After discussion with my teacher we decided combo boxes was the best solution (im open to other suggestions) However we cant come up with method to cascade the combo boxes :confused:. I need to cascade the four defenders boxes together, the four midfielders together and lastly the two attackers.
Ive tried to do this using an update query but the problem with that is its updating all the records rather than jus the one I dont no what else i can do and im really hoping one if u's cazn help. Im also tryin to make the user not be able to select more than 2 players from the one team if anyone knows how t create some sort of validation rule for that
Thx alot
Ramsjammin
View 1 Replies
View Related
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
Dec 7, 2012
I run a soccer league where we track players attendance for each game. I currently do it on a spreadsheet where each game date is a column and each player is a row. We also track which team they play on at each game (they can play on different teams different weeks). I currently have a second tab in the spreadsheet to record which team a person plays on each week.
Setting up a table of fields for this is relatively easy. The problem comes to data entry. I want to be able to visually see the data like I can in a spreadsheet (names in rows, dates in columns, intersections containing either team name or whether attended) and whilst a cross-tab query gives me the layout, I cannot input data in a cross-tab query.
View 1 Replies
View Related
Apr 4, 2014
I'm currently trying to create a form which allows the specific users to book a seat at a football match.
I've created all the relevant tables, but I'm struggling on how to interpret the data into them to make the form work. I am new to this sort of design, this design is currently for my university dissertation and I am struggling to get it completed in time.
I have attached my document below to show how far i have come.
View 1 Replies
View Related
Sep 29, 2013
How can I update (some columns) in a table from the same table based on a Criteria column in the same table.
View 2 Replies
View Related
Jun 28, 2013
I need to get x and y coordinates for each device, but the data has to get looked up from 2 other tables.
I have a table (called InstReclosers) that has device names. Each device is on a Section. I can go to another table (called InstSections) and look up what Node that particular section is tied to. Then I need to go to another table (called Nodes) to get the X and Y location for that particular node.
How I can go about getting this X and Y data into the InstReclosers table?
...in summary, InstReclosers has device name and section name. InstSections has section name and node name. Nodes has node name and XY coords. Need XY coords for each device in InstReclosers.
View 3 Replies
View Related
Jan 29, 2015
When I try to transfer (ctrl c + v) data from a table in Excel to a table in Access it loses format.
Exemple: $ 1.000,00 (Excel) become 1000 (Access).
I need to keep the format to make sure that the code works properly.
View 9 Replies
View Related
Nov 4, 2014
I have a make-table query that pulls all the fields from 1 table (MainTable), and creates a new table with a date stamp based apon a form value entered (New Table = MainTableWithDate).
Currently, I setup the query to pull info from the form field like this:
DateField: [Forms]![frmmain]![DateField]
However, when the make-table query is done - all date fields are blank (all other fields are correctly created), and when I look at the new created table (mainTableWIthDate), the typeassigned to the date field is "Binary" (in the form, I've specified LongDate).
View 6 Replies
View Related
Aug 5, 2014
I have a table products with a field "id_product" and "total" (Total items in stock)
I have a query with the fields "id_product" and also the field "total in stock"
I want an update query to update the field 'total' in table 'products' with infos from that query
For each id-product in table products, replace the field total with the field 'total in stock' from the query
So I want to update a filed in a specific table with infos form another table.
View 2 Replies
View Related
Apr 19, 2013
Here's a query that the bottom listview in the attached form i.e. a listview representing a table of calls(many) to fims (1 top listview)
Code:
SELECT calls.id, calls.firm_id, calls.called, calls.said, calls.spoke_to, calls.next
FROM calls
WHERE (((calls.firm_id)=[firms].[id]))
ORDER BY calls.called DESC , calls.next DESC;
When I run the thing...I get a dialog asking me for firm id.
I want to change this so when I move up and down the firms LV (top)... the bottom LV updates taking firm id from the top LV with focus.
Access 2003.
View 2 Replies
View Related
Jan 13, 2014
I have an MS Access accdb with linked SQL Server 2012 ODBC tables. I am working on a procedure to copy data from local tables to these linked tables (identical schema). I did a simple
Code:
DoCmd.RunSQL "INSERT INTO linkedTable SELECT * FROM localTable"
This works, but is very slow. Way too slow. (INSERT copies the data one record at a time).
I would like to copy the data in a bulk operation, or operations that I can execute programmatically.
View 1 Replies
View Related
May 28, 2015
I have a table for a multiple parents linked to a child table. I need to figure out a way to only allow 1 parent to be coded as primary, 1 as secondary, and then the rest as other... I thought about making Primary/Secondary/Other a primary key. But then I can only have 1 other. I would have to make a finite number of parents that could be entered and I want an infinite number.... My end goal is to have a report that only has a primary and second parent on it, but the rest of the parents still exist in the table...
*Child_ID
Parent_First_Name
*Primary/Secondary/Other
View 8 Replies
View Related
Sep 12, 2014
How to make a form open with data from a table based on a date and time in the/a table?
View 7 Replies
View Related
Aug 29, 2006
Hi,
I am extracting data from linked db2 table using access make table query. First I create a select query and can view the linked db2 data, but when I change to a make table query I get an error message, "invalid argument", when I run the make table query. There is no selection critera specified. Has anyone had this happen? and Do you know a solution?
Thanks for your support
GinnyP
View 1 Replies
View Related
Nov 24, 2006
Ok my problem is this......
I have a form with a field "Property Status" on it. It has 4 possible values -
"C - SHELTERED (with warden charge)";"H - SHELTERED (No warden charge)";"J - WHEELCHAIR SHELTERED (With warden charge)";"M - WHEELCHAIR SHELTERED (No warden charge)";"X - DISCONNECTED"
When the value "X - DISCONNECTED" is selected in the form I want the record to be removed from its existing table and sent to a new table which keeps all the "X - DISCONNECTED" records together.
Any ideas would be greatly appreciated. How would this be coded?
View 1 Replies
View Related
