Access Query and ASP

[larkee]

I have an access 2000 database with a query that qalculates a distinct player score average by emailID.
-------
SELECT DISTINCTROW Rounds.eMailID, Avg(Rounds.Score) AS [Avg Of Score], Count(*) AS [Count Of Rounds]
FROM Rounds
GROUP BY Rounds.eMailID;
--------

I need to write this average to (Players) Table in the pAverage Column of each (EmailAdress)

Your Help is appreciated

 

[GingerR]

hi--first, it is not good practice to save calcluated data in a table for the mere fact that the numbers could change. Are you using ASP too? you can display the calculations just as you would in Access instead of storing them in a table.

having said that, i'm guessing that what you are running into is "Must use an updateable query" error.....you have to write your results from your query above into a separate temporary table first, then write an update query to update the records in your Players table. Is this something you only have to do once, or all the time as data in the Rounds table is edited?

g

 

[larkee]

I acually have the query in the database writing to the asp page now.