Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: eieio
  • Order by date
  1. eieio

    query the same table more than once

    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...
  2. eieio

    query the same table more than once

    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...
  3. eieio

    Multiple queries of the same table

    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...
  4. eieio

    Code for an If Statement

    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...
  5. eieio

    Multiple queries of the same table

    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...

Part and Inventory Search

Back
Top