Re: Update Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

AHHHHH. Nowhere in any of your previous posts could I find where you
indicated that this is all related to other tables. That information might
have helped :-)


Sorry.


--
Rick B



"Paul W Smith" <pwsNOSPAM@xxxxxxxxxxxx> wrote in message
news:43cd4fac$0$1482$ed2619ec@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> What you were suggesting I have always understood...you have not tried to
> understand what I have been replying.
>
> I CANNOT JUST ENTER HISTORIC DATA IN THE CURRENT DATA TABLE!
>
> The current data is interdependent on other tables.
>
> Each Score line must have a Pair Reference from the Pairing table. Each
> pair, and there are two for each fixture must reference a reference in the
> fixture table. Each Fixture must reference a season from the season
> table. This high score is a minor issue and the database design has been
> create to fulfil other criteria.
>
> I appreciate your help, but really you are going down a blind alley on
> this one as I have tried to point out.
>
> If I could get the other line of update query working I would have
> everything I need alas I cannot.
>
> Funny I cannot seem to get DLookup or DSum to work in any form!
>
>
>
>
> "Rick B" <Anonymous> wrote in message
> news:e8IcxB6GGHA.2704@xxxxxxxxxxxxxxxxxxxxxxx
>> No problem. We must be miscommunicating. I am not saying to add in all
>> the historical data. Just add one record for their previous high score.
>> Let's say "The Bears" got a high score of 26 in September of 2004. They
>> played many games before that and many after that, but none of them
>> matter. Just add in that one particular game and the score. Then, from
>> this point forward, log all your games just like you normally would.
>>
>> When you run your query to find the "high score" it will search through
>> all the games in your database that "The Bears" have played. It will
>> find all the current games, plus one old game out there from September of
>> 2004. If they have not broken their record since September 2004, then
>> that is the record that will pull up. You will then know that their high
>> score is 26 and that they did it 09/04. If they have scored higher since
>> then, the new high score would be the one selected.
>>
>> This will require only one table. The table would have the TeamName, The
>> Date of the game, and the score. That's all. You could query this table
>> and pull the DMAX or TOP to grab the highest score.
>>
>> All you have to do is look at your current Table1 and make one new record
>> for each Team.
>>
>> Current Table1...
>> The Bears 26
>> The Whitesox 12
>> The Jets 24
>> etc.
>>
>> New Table...
>>
>> 09/01/04 The Bears 26
>> 01/07/06 The Bears 14
>> 01/14/06 The Bears 12
>> 08/01/04 The Whitesox 12
>> 01/07/06 The Whitesox 16
>> 01/14/06 The Whitesox 8
>> 12/01/04 The Jets 24
>> 01/07/06 The Jets 12
>> 01/14/06 The Jets 16
>>
>>
>> If you don't know the date of their previous high score, then put in some
>> bogus date like 01/01/1900.
>>
>>
>>
>>
>>
>> --
>> Rick B
>>
>>
>>
>> "Paul W Smith" <pwsNOSPAM@xxxxxxxxxxxx> wrote in message
>> news:43cd3134$0$1483$ed2619ec@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>> Thanks for you help, but you are not understanding.
>>>
>>> The table which gets updated whenever a match is played contains more
>>> than just the score. I do not have this information for historic games.
>>> Therefore I cannot just add historic records.
>>>
>>> I am hopeful that Duane's advice might produce a answer for me, so again
>>> many thanks.
>>>
>>>
>>> "Rick B" <Anonymous> wrote in message
>>> news:edUR4y4GGHA.1452@xxxxxxxxxxxxxxxxxxxxxxx
>>>> If you do not have the required add'l data, just enter X's. It is one
>>>> record for each team.
>>>>
>>>> --
>>>> Rick B
>>>>
>>>>
>>>>
>>>> "Paul W Smith" <pwsNOSPAM@xxxxxxxxxxxx> wrote in message
>>>> news:43cd2a02$0$1476$ed2619ec@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>>>I do not think I am making myself clear to you. I cannot just add a
>>>>>record into my current table for a historic performance - I do not have
>>>>>the required additional data.
>>>>>
>>>>> I therefore have to add the old and compare this against the new.
>>>>>
>>>>>
>>>>> "Rick B" <Anonymous> wrote in message
>>>>> news:OuyBQh4GGHA.2320@xxxxxxxxxxxxxxxxxxxxxxx
>>>>>> I'd probably just add one record for the previous high score into my
>>>>>> single table. Then you would have that record. If any are higher in
>>>>>> the future, then they will be selected and that original record will
>>>>>> never be looked at again.
>>>>>>
>>>>>> Another post here explains how to build a query to pull the highest
>>>>>> record.
>>>>>>
>>>>>> --
>>>>>> Rick B
>>>>>>
>>>>>>
>>>>>>
>>>>>> "Paul W Smith" <pwsNOSPAM@xxxxxxxxxxxx> wrote in message
>>>>>> news:43cd2269$0$1448$ed2619ec@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>>>>> Granted what you say is true.
>>>>>>>
>>>>>>> My problem is getting the historic information into the database. I
>>>>>>> do not have all the necessary data to create a record for the
>>>>>>> previous historic high score, so what I need is a way to have a
>>>>>>> position so far, which can then be updated.
>>>>>>>
>>>>>>> If anyone has an alternative idea please let me know.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> "Rick B" <Anonymous> wrote in message
>>>>>>> news:%23vPMVY4GGHA.140@xxxxxxxxxxxxxxxxxxxxxxx
>>>>>>>> Generally, you would not need that high score table. When you run
>>>>>>>> a query, it is easy to pull the highest score for a given team. It
>>>>>>>> would also be up-to-the-minute. If a team breaks their record
>>>>>>>> during the current season, your high score table is inaccurate
>>>>>>>> until the end of the season when you run this update you are
>>>>>>>> talking about.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> Rick B
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> "Paul W Smith" <pwsNOSPAM@xxxxxxxxxxxx> wrote in message
>>>>>>>> news:43cd190a$0$1451$ed2619ec@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>>>>>>>>I have two tables, one contains the highest score each team has
>>>>>>>>>ever achieved - this has been manually built loaded from the
>>>>>>>>>leagues historical records.
>>>>>>>>>
>>>>>>>>> I written a query that produces, for each team, it's highest score
>>>>>>>>> of the current season.
>>>>>>>>>
>>>>>>>>> I am to know how I would go about writing an update query that
>>>>>>>>> would update my first table where the value in the second table is
>>>>>>>>> greater than that in the first.
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Update Query
    ... I CANNOT JUST ENTER HISTORIC DATA IN THE CURRENT DATA TABLE! ... Just add one record for their previous high score. ... log all your games just like you normally would. ... > all the games in your database that "The Bears" have played. ...
    (microsoft.public.access.queries)
  • Re: Update Query
    ... >> Each Score line must have a Pair Reference from the Pairing table. ... >> the fixture table. ... This high score is a minor issue and the database design has been ... log all your games just like you normally would. ...
    (microsoft.public.access.queries)
  • Re: California Extreme 2007 Schedule!
    ... Signups for teams for this competition will be ... Greg will be on-hand to discuss the film after its ... "High Score" is a highly praised documentary about a single man's ... games were bringing in enough quarters to fill the Rose Bowl. ...
    (rec.games.video.arcade.collecting)
  • Re: Leaderboard Challenge: Rules, Dates, Games and SignUp
    ... Between now and the end of May, play as many of the games listed below as ... and points awarded for position on each, with the top score on a leaderboard ... Geometry Wars 2 (Evolved high score) ...
    (uk.games.video.misc)
  • Re: Leaderboard Challenge: Rules, Dates, Games and SignUp
    ... Between now and the end of May, play as many of the games listed below as ... and points awarded for position on each, with the top score on a leaderboard ... Geometry Wars 2 (Evolved high score) ...
    (uk.games.video.misc)