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!

Register Log in
  • Congratulations Chriss Miller 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: pwbrown
  • Order by date
  1. pwbrown

    Ranking

    That just erased all the players from the database. The Handicaps are still in the player information table, but the player names have been deleted. Here is the code that was used: UPDATE tblFriday AS F INNER JOIN [SELECT P.[Player #], P.Player, P.Handicap, S.rank FROM [Player...
  2. pwbrown

    Ranking

    Only one problem... when it updates it updates the field [player] in the tblFriday with the players number and not their name. I understand that player # was used earlier to make a unique value, but when I try to add player I keep getting syntax errors.
  3. pwbrown

    Ranking

    Almost there, this is great!!! The last thing is transfering the ranks into a pre-made table. Since the final pairing is done by ranking, everything such as times and amounts are already there, all that has to be done is to load the players. I have created a query (select) that has the info...
  4. pwbrown

    Ranking

    Do I need to start a new query with this SQL, or can I add it to the existing? I tried adding this to the bottom which changed the code to the following, but syntax erros poped up all over the place... SELECT [Player Information].[Player #], [Player Information].Player, [Player...
  5. pwbrown

    Ranking

    It is somewhat working now. The problem is that the score goes from 57 for ranking 10 to (2) 61's. In the query each 61 is ranked as 12. I need one to be ranked 11 and the second to be ranked 12. When the score is the same, I don't care how it differenciates which one would be 11 and the...
  6. pwbrown

    Ranking

    What is meant by "unique ID number"? Also, am lost as to what "somenumbers as a"... I am an extreme novice at SQL, any guidance is greatly appreicated.
  7. pwbrown

    Ranking

    Below is the current SQL that I have been working on. However it only shows the total and every record has the ranking of 12. So there are 12, 12's SELECT (SELECT Count (*) From ranking where total <= ranking.total) AS ranking, s.Total FROM ranking AS s ORDER BY 1; "Ranking" = query that has...
  8. pwbrown

    Transfering data from on form to another

    I have tried this, but the error Can't assign a value to this object keeps coming up when the button is clicked... Button on click Dim AreaNumber As String AreaNumber = 7961 DoCmd.OpenForm "frmPullChordTracking", , , , , , AreaNumber other form On Open event Me.Text43 = Me.OpenArgs Any...
  9. pwbrown

    Transfering data from on form to another

    Not sure what you mean by OpenArgs? Don't mean to sound stupid, but this is rather new to me.
  10. pwbrown

    Transfering data from on form to another

    On the main form there are a series of buttons, each one representing a different area. Once clicking the button a new form opens. What I would like to have happen is that when the area button is clicked the field [area] on the new form is automatically filled in with the appropriate area...
  11. pwbrown

    Ranking

    I have tried looking at the key word, and looks like one would help, but I am getting lost in what to put where....
  12. pwbrown

    Assign points based on value

    This seems so close to what I am needing but I am getting lost in the code and what goes where. I currently have a query [Ranking] that has a calculation that totals [Total]scores. What I am needing to do is rank the scores in a new field [Rank] that will update the field [Ranking] in the table...
  13. pwbrown

    Ranking

    In the query, there is a calculated field that has a number either a positive or negative number, possibly 0. What I need the query to do is arrange the data from the lowest number to the highest like -66 -45 -30 0 34 45 61 61 (Yes there maybe duplicates, but within the duplicate, it does not...

Part and Inventory Search

Back
Top