Search results

Jiri, I am trying to work this out through my mind. With the tblGame and tblGTSC, then I still multiple records that need to be on 1 line in my recap form ... correct? Thanks! Robecca

Jiri, I will have to take time to process what you are showing me. I will get back to you today or tomorrow. Thank you! Robecca

Jiri, Let me see if I am grasping this b/c I don’t feel I am. I should call my table Game instead of Score b/c our score bowled is an attribute of the Game. My Game table should have: GameID Sequence Number (representing Game1 – Game4) Date Lane Number L Position M Position A Position...

Jiri, Thank you for responding. I either gave too much information on CheckInID or I am lost. :confused: My goal with my Score table is to capture by bowler, the game# & score bowled. I was including Lane# b/c we switch lanes after each game and thought that was the place to put it. I...

I am building a bowling database and I had a tabbed form for entering games, however, my brother would rather have a form that looks like a recap. I don’t know how to get a form to look like this when it takes 4 records per bowler. My Scores table has these fields: ScoreID (PK) CheckInID (FK...

I tried yesterday the switching of ChkTeamID to TeamID in the TeamBonusPoints table. Seemed to work fine until I did a query with the CheckInTeam and then I was getting multiple lines per team/game. I ended up deleting ChkInID from the CheckInTeam table and putting the ChkTeamID into the...

My purpose is to relate bowlers and teams. Actually we do want to see past team lineup & results. I will give your suggestion a try tomorrow, since I'm bowling tonight, I won't be back on before then. Have a great evening!

@ Plog All rounds are calculated in the total match points. Difference is Round 1 does not get any bonus points. Lanes are reshuffled after each game b/c we want the team in the lead to bowl the 2nd leading team and so forth. We track the individual bowler’s score by game. Team scores...

Sorry, thought the background information would be helpful. 2. Scores are never discarded, next round is added. Teams get extra 10 points by having a better round against the team they are squaring off against. 7 teams will get an extra 10 points

Hi Our summer league (Scratch Trio) is different b/c we pay out $ to the top 6 teams each week (we bowl on Tuesday nights). We bowl on sport or PBA patterns. We have 14 teams, blind draw, which means new teams of 3 each week based on the Scratch Trio average at the beginning of that night. We...

I had all my tables built and I started desiging my queries for my forms. I did not have any problems with my tables until now, when I started to bring build the queries/forms for team points. My database is for our summer bowling league. We have teams of 3, each week we draw for team...

I think I have an issue with my table structure. I am opening a new thread under tables. If you don't mind looking, I would appreaciate it. Thanks! Robecca

I see my mistake. A rookie mistake for me ... I had the control being ChkInID and then when I thought I just needed ScoreID in the form, I just changed the control scource and not the name - done it tons of times before, just spaced the two-step process this time. I also see that I actually...

Sorry for the delay ... first chance this evening to get on the computer. I don't know what I am to change the control name for ScoreID to (anything?) - it looks like it is still ScoreID on the amended dbase you attached. EG David Warrick ScoreID on game1 = 1861, ScoreID on Game2 is 1862. The...

If I don't have the WkDate set with criteria of Date(), how do I get only that evening's games in my form? I had been wondering if I needed ChkInID on my form Game2, is that what you meant? I would love to have suggestions, most of my Access databases have been simple, this is the most...

Sorry, I mis-typed above. I have only one table (Score) with the fields listed in that first message. I meant I had 4 forms for Game1-Game4 for 2 reasons. 1. I wasn't sure how to get them all in one form. 2. We change lanes after each game and I want the form to be organized by lane and...

Here it is ...

Yes, I removed the single quote. =DLookUp("[Score]","Score","ChkInID=" & [Forms]![Game2].[ChkInID] & " and [GameID] = 1") returns empty cells for everyone I even tried: =DLookUp("Score","Score","ChkInID=" & "ChkInID" & " and GameID = 1") returns David's Score for all bowlers I'm missing...

Sorry, the example did not come out formatted well.

Better ... the #Name? is gone however, all I have is an empty text box. Could the fact that I have 4 entries for that same ChkInID be an issue? My data in that table can look like: ScoreID ChkInID GameID LaneID Score 456 33...