Subtotals in queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi
I have just learnt how to retrieve the Top 6 events (by date). There are now
40 sets of different events. Each event has a decimal score. I would like to
do a complex statistical calculation (or a subtotal would be a good guide) on
each set and make it part of a table say. I know it can be done via a report
but eventually I need to graph only any event exceeding a certain score.
 
Complex statistics and graphing are better done in a spreadsheet. Export your
query results to Excel and have at it there.
 
Back
Top