Update Access dB (baseball stats)

Results 1 to 2 of 2

Thread: Update Access dB (baseball stats)

  1. #1
    Join Date
    Dec 1969

    Default Update Access dB (baseball stats)

    I am trying to build an ASP page that requests data from a form then updates a Access dB based upon a criteria, that being:<BR><BR>SET a bunch of fields WHERE the row is equal to the uniform number selected.<BR><BR>Now if you can imagin, there are a lot of baseball stats! I know how to change all the rows in a field but thats points less. I&#039;d like to change every field at once (games played, at bats, hits, walks, homeruns, etc...) based upon the players uniform number...I&#039;m having a difficult time figuring this out.<BR><BR>I appreciate any help offered!<BR><BR>Thanks<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Update Access dB (baseball stats)

    SQL = "UPDATE table SET gamesPlayed=gamesPlayed+1, atBats=" & newAtBats _<BR>&nbsp; &nbsp; &nbsp; ",hits=" & newHits & ",walks=" & newWalks _<BR>&nbsp; &nbsp; &nbsp; ",homeruns=" & newHomeruns & ",RBI=" & newRBI _<BR>&nbsp; &nbsp; &nbsp; " WHERE playerNumber = " & player & " AND teamNumber = " & team<BR><BR>Nothing to do with Access. That&#039;s good old fashioned very generic SQL.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts