Search results for query: *

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

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.

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

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

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

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.

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

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

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

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

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

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

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