averaging data

[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

 

[Al Campagna]

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."

 

[Al Campagna]

GC,
Sorry, I thought you were doing percentages.
Use the same Totals query, Group on Date, but Average on
your values.
--
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."

 

[GC]

Thanks Al, i will give that a try.

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."

 

[Al Campagna]

Post back... we always like to know if our suggestions
work/don't work out.
--
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."