averaging data

  • Thread starter Thread starter GC
  • Start date Start date
G

GC

Hi, I have a program that collects data throught out the day and populates
an Access table. This goes on everyday. I collect various data but the
important ones to mention here is the date and percent error. I wish to show
the average error for each day in a query.
Is this the best way and if so how does one do this.

Cheers
Gerry
 
GC,
Create a "Totals" query (in query design mode menu... View/Totals).
You would Group on the date value, and probably Sum the value
data. This should yield totals for the day... from which you can calculate
the percentages of those summed values.
See Help on Totals Queries...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Thanks Al, i will give that a try.
Al Campagna said:
GC,
Create a "Totals" query (in query design mode menu... View/Totals).
You would Group on the date value, and probably Sum the value
data. This should yield totals for the day... from which you can
calculate
the percentages of those summed values.
See Help on Totals Queries...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
Click to expand...
 
Back
Top