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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating Subtotals in Access Reports but under certain criteria. 5
Calculating totals/subtotals 2
SumTop 3 Values of Query Result 1
Access 2010 append query to SQL is very slow 0
Access Subtotal in Query 3
Need to create different files based on subtotal 1
Do I need a Crosstab Query 20
Average of Subtotals in Pivot Table 0

Back
Top