Forums
This topic is locked
table suming difficulty
Posted 20 Jan 2002 19:00:27
1
has voted
20 Jan 2002 19:00:27 Stuart Chase posted:
I have an Access2K database in it is a table (tblScores) this is populated as Moderators enter scores.I made 2 queries in access - the first groups all the day's worth of records for the current month - by callsign, the second query takes the first query and add's every callsign's respective scores together. (not sure why, but I couldnt do it in one Query)
Then I have asp display the last query.
Is there an easier method - maybe by asp grouping by month instead of an access query. And to also show every callsign - not just those with a score? (like zero's in place of the score total).
Have fields
Callsign, No. Flights, Score, Kills, Death, Last Flown.
Would also like for someone to be able to select by a drop down box - any particular month and have it show the score sheet for that month.
Any ideas?