John, I will try to explain this. I am tracking scores, win, losses, and standings in Basketball league with 650 kids and about 70 teams. Hopefully you are a sports fan.
The record source of my report is a query (q_EventScoreInputMultiGame)
It pulls the event number from the 1st table below (t_facilitySchedule) and the participant information from the second table below (t_EventParticipants)
My events are stored in a table called
t_facilitySchedule
The fields are
fscfscID , which is the PK, which is also the Event number. I will eventually hide this.
fscFacID, which is a FK to the Facility Name
There are 4 more fields that indicates the Sport, Date, Start time, and Stop Time.
I have a second table that lists event participants. As you suggested the participants are in a separate table.
The table name is
t_EventParticipants
The fields are
gteGteID, which is the PK
gteFscID, which is the FK that related to the table above.
gteTnaID, which is FK to the Team Name table
gteDesID, which is a FK which designates HOME team or VISITOR team. 1 or 2.
gtePoints, which is how many points a team scored in an event.
gteResID, which is a FK to a table which indicates if the team won the event, 1=Win, 2=Loss, 3=Tie. I have to put this in manually since I can't figure out how to do it manually.
So the report looks like this, it is hard to pick out the games.
61255 , Lakers , 1 , 21 , 2 (This reads- In event 61255 the Lakers were the Home team and scored 21, they lost)
61255 , Bulls , 2 , 32 , 1 (This reads- In event 61255 the Bulls were the Visitor team and scored 32, they won)
61256, Cavs , 1 , 22, 1
61256, Spurs , 2 , 19, 2
61257, Heat , 1 , 27, 1
61257, Bucks , 2 , 24, 2
I was hoping to have it look like, it is easier to read.
61255 , Lakers , 1 , 21 , 2
Bulls , 2 , 32 , 1
61256, Cavs , 1 , 22, 1
Spurs , 2 , 19, 2
61257, Heat , 1 , 27, 1
Bucks , 2 , 24, 2
The point is that I am trying to find an efficient way to input the scores that is not prone to error. I have to put in the score and then the 1 or 2 to determine a win or loss.
Ideally I would like the score inputting all on one line like below, but when I do that I get a record that is not editable.
61257 Heat , 27 1 , Bucks , 24 , 2
It would also be great if I could have the program determine who was the winner and input a 1 or 2 based on the score that I put in. Putting in a 1 or 2 was the only way I could calculate wins and losses and team standings for the end of the year playoffs. So now I just added another question.
Clear as Mud
Thanks for any tips you can provide.
Bill
MN
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, January 27, 2015 2:39 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Sorting a form?
Bill-
What is the Record Source of your form? If you want to see only events, don't include participant info. I assume events have their own table. If not, then perhaps that's your problem.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
On Jan 27, 2015, at 9:25 PM, 'Bill Singer' Bill.Singer@at-group.net <mailto:Bill.Singer@at-group.net> [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com <mailto:MS_Access_Professionals@yahoogroups.com> > wrote:
I am wondering if there is a way to GROUP records on a form like I can GROUP records in a report. I have 25 events and 50 participants. I am using a continuous form so that I can see all the events and participants.
I would like to see only 25 event IDs ( 1 for each event) but now, since the event ID is on the continuous form I see the event ID 50 times, once with each participant.
Any thought?
Bill
MN
Posted by: "Bill Singer" <Bill.Singer@at-group.net>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar