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

"GC" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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,
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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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
>

Thanks Al, i will give that a try.
"Al Campagna" <(E-Mail Removed)> wrote in message
news:Osg%(E-Mail Removed)...
> 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."
>
> "GC" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> 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
>>
>
>

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

"GC" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks Al, i will give that a try.
> "Al Campagna" <(E-Mail Removed)> wrote in message
> news:Osg%(E-Mail Removed)...
>> 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."
>>
>> "GC" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> 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
>>>
>>
>>
>
>