A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Averages?



 
 
Thread Tools Display Modes
  #1  
Old September 12th, 2005, 03:52 PM
RTimberlake
external usenet poster
 
Posts: n/a
Default Averages?

I know that there is a way to calculate averages in Access. But, where do you
put the equation and how should it look. I need to get the average of three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as show up
on my form.
Any help that you can give would be greatly appreciated.
  #2  
Old September 12th, 2005, 04:21 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average, use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

"RTimberlake" wrote in message
...
I know that there is a way to calculate averages in Access. But, where do
you
put the equation and how should it look. I need to get the average of
three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as show
up
on my form.
Any help that you can give would be greatly appreciated.



  #3  
Old September 12th, 2005, 04:29 PM
RTimberlake
external usenet poster
 
Posts: n/a
Default

Where would I put that equation?

"Duane Hookom" wrote:

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average, use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

"RTimberlake" wrote in message
...
I know that there is a way to calculate averages in Access. But, where do
you
put the equation and how should it look. I need to get the average of
three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as show
up
on my form.
Any help that you can give would be greatly appreciated.




  #4  
Old September 12th, 2005, 06:17 PM
Rick B
external usenet poster
 
Posts: n/a
Default

In an unbound field in your query or form.

--
Rick B



"RTimberlake" wrote in message
...
Where would I put that equation?

"Duane Hookom" wrote:

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average,

use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

"RTimberlake" wrote in message
...
I know that there is a way to calculate averages in Access. But, where

do
you
put the equation and how should it look. I need to get the average of
three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as

show
up
on my form.
Any help that you can give would be greatly appreciated.






  #5  
Old September 12th, 2005, 07:12 PM
RTimberlake
external usenet poster
 
Posts: n/a
Default

If I do that will I be able to save the figure in a table so it can be
accessed later?


--Rebecca


"Rick B" wrote:

In an unbound field in your query or form.

--
Rick B



"RTimberlake" wrote in message
...
Where would I put that equation?

"Duane Hookom" wrote:

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average,

use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

"RTimberlake" wrote in message
...
I know that there is a way to calculate averages in Access. But, where

do
you
put the equation and how should it look. I need to get the average of
three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as

show
up
on my form.
Any help that you can give would be greatly appreciated.






  #6  
Old September 12th, 2005, 07:15 PM
RTimberlake
external usenet poster
 
Posts: n/a
Default

One more question...Is there a way to pull the information from three table
entries to form one average?
It may help you to know what I am trying to accomplish. I am creating a
database for employee evaluations. We have three people fill out the
evaluation. At the end I need a report to give me the averages of the three
evaluations. I hope this makes sense.

"Rick B" wrote:

In an unbound field in your query or form.

--
Rick B



"RTimberlake" wrote in message
...
Where would I put that equation?

"Duane Hookom" wrote:

If your table was properly normalized, you would use a totals query that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the average,

use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

"RTimberlake" wrote in message
...
I know that there is a way to calculate averages in Access. But, where

do
you
put the equation and how should it look. I need to get the average of
three
feilds in my table. They are named: Communication, Decision Making and
Observation. I want this average to be stored in my table as well as

show
up
on my form.
Any help that you can give would be greatly appreciated.






  #7  
Old September 13th, 2005, 02:26 AM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

I wouldn't go any further until the application was normalized. There is a
good starting point in the sample employee evaluation at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.

Regarding your question about storing the average... you shouldn't.

--
Duane Hookom
MS Access MVP


"RTimberlake" wrote in message
...
One more question...Is there a way to pull the information from three
table
entries to form one average?
It may help you to know what I am trying to accomplish. I am creating a
database for employee evaluations. We have three people fill out the
evaluation. At the end I need a report to give me the averages of the
three
evaluations. I hope this makes sense.

"Rick B" wrote:

In an unbound field in your query or form.

--
Rick B



"RTimberlake" wrote in message
...
Where would I put that equation?

"Duane Hookom" wrote:

If your table was properly normalized, you would use a totals query
that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the
average,

use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

"RTimberlake" wrote in
message
...
I know that there is a way to calculate averages in Access. But,
where

do
you
put the equation and how should it look. I need to get the average
of
three
feilds in my table. They are named: Communication, Decision Making
and
Observation. I want this average to be stored in my table as well
as

show
up
on my form.
Any help that you can give would be greatly appreciated.








  #8  
Old September 13th, 2005, 01:42 PM
RTimberlake
external usenet poster
 
Posts: n/a
Default

What do you mean by "normalized?"

"Duane Hookom" wrote:

I wouldn't go any further until the application was normalized. There is a
good starting point in the sample employee evaluation at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.

Regarding your question about storing the average... you shouldn't.

--
Duane Hookom
MS Access MVP


"RTimberlake" wrote in message
...
One more question...Is there a way to pull the information from three
table
entries to form one average?
It may help you to know what I am trying to accomplish. I am creating a
database for employee evaluations. We have three people fill out the
evaluation. At the end I need a report to give me the averages of the
three
evaluations. I hope this makes sense.

"Rick B" wrote:

In an unbound field in your query or form.

--
Rick B



"RTimberlake" wrote in message
...
Where would I put that equation?

"Duane Hookom" wrote:

If your table was properly normalized, you would use a totals query
that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the
average,
use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

"RTimberlake" wrote in
message
...
I know that there is a way to calculate averages in Access. But,
where
do
you
put the equation and how should it look. I need to get the average
of
three
feilds in my table. They are named: Communication, Decision Making
and
Observation. I want this average to be stored in my table as well
as
show
up
on my form.
Any help that you can give would be greatly appreciated.









  #9  
Old September 13th, 2005, 02:21 PM
Duane Hookom
external usenet poster
 
Posts: n/a
Default

Did you look at the demo I posted? I would not use Communication, Decision
Making, and Observation as field names. The demo uses them as values in a
field. Each individual rating creates a record in a table rather than having
a multiple field table.

The normalized solution is easier to maintain since you can add evaluation
points without having to change table structures, forms, reports,....

--
Duane Hookom
MS Access MVP
--

"RTimberlake" wrote in message
...
What do you mean by "normalized?"

"Duane Hookom" wrote:

I wouldn't go any further until the application was normalized. There is
a
good starting point in the sample employee evaluation at
http://www.rogersaccesslibrary.com/O...p#Hookom,Duane.

Regarding your question about storing the average... you shouldn't.

--
Duane Hookom
MS Access MVP


"RTimberlake" wrote in message
...
One more question...Is there a way to pull the information from three
table
entries to form one average?
It may help you to know what I am trying to accomplish. I am creating a
database for employee evaluations. We have three people fill out the
evaluation. At the end I need a report to give me the averages of the
three
evaluations. I hope this makes sense.

"Rick B" wrote:

In an unbound field in your query or form.

--
Rick B



"RTimberlake" wrote in message
...
Where would I put that equation?

"Duane Hookom" wrote:

If your table was properly normalized, you would use a totals
query
that
averages the "scores" by evaluation or whatever.

However, if all the fields will have values to include in the
average,
use
=([Communication] +[Decision Making] + [Observation])/3

--
Duane Hookom
MS Access MVP
--

"RTimberlake" wrote in
message
...
I know that there is a way to calculate averages in Access. But,
where
do
you
put the equation and how should it look. I need to get the
average
of
three
feilds in my table. They are named: Communication, Decision
Making
and
Observation. I want this average to be stored in my table as
well
as
show
up
on my form.
Any help that you can give would be greatly appreciated.











 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Averages Robert Running & Setting Up Queries 5 September 27th, 2005 11:23 AM
Averages Calculations Robert Setting Up & Running Reports 2 September 27th, 2005 01:32 AM
Average of averages Office User Setting Up & Running Reports 9 May 2nd, 2005 09:21 PM
Select a range of records for use in moving averages daverinda Running & Setting Up Queries 2 November 19th, 2004 10:45 PM
Dates and Averages Bill Worksheet Functions 0 October 6th, 2003 11:28 PM


All times are GMT +1. The time now is 10:34 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.