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?


Reply to this topic