Well, I'm not sure that I understand. In my table I have multiple rows not columns. Is that what you mean?
I use this to keep score of league matches (pool). In every match, there are two teams. For each team you have up to seven players and each of these players may play up to 5 games...
I have a table which contains the following fields:
Match, Team, Player, Game, Score
Because in every match a player will play up to five different games, I need
my form to be in the following format:
Match, Team, Player, Score, Score, Score, Score, Score
The "Game" fields fill in...
Thanks Kathyrn.
Yes that's a lot. My problem with designing the database the way you described is then being able to get all of the information that I need out of it. I had it structured similarly to that originally, but then couldn't figure out (and neither could the newsgroup guru's) how to...
I need to write an If statement for transferring data from unbound text boxes to several (ok - 50) different subforms.
I have NO IDEA how to do this. I think I know what I want to say but don't know how to say it - -
I need a statement that will evaluate each box on THREE merits and then...
I have a table which has the following fields:
Match,Game,Player,Round,and Score.
What I need to be able to do is to have one query which will allow me to list ONE time the Match,Game and Player and also allow me to list 5 different Rounds and Scores.
For example:
Match, Game, Player, Round1...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.