Averaging daily records of a query table

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

Guest

I am a novice at Access 2003 (MS Office Professional). I have created a
query table that shows profitability for each sales ticket we generate. The
number of records we have vary from 1 - 75 per day. My problem is that I
need to have a daily average. Is that possible? I have a different number
of sales (i.e. records) for each day. I have established a parameter criteria
to show specific days records and have been able to export it to a worksheet
in Excel to acheive this currently but would prefer it to stay in Access.
Any Ideas?
 
You need to create a totals query.

Create a query with the datefield and the Profit
Click View: Totals from the menu
Change GROUP BY under one of the profit field to Avg

If you also want a count of the tickets, add the profit field again and
change the Group By to Count

Run the query.
 
Back
Top