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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |