Simple adding made hard - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

Simple adding made hard

Author

Topic

dzirkelb
Yak Posting Veteran

53 Posts

Posted - 2004-08-12 : 11:12:56

I need some help in the logic on how to go about this...here is the scenerio:

Using front page 2003
Pulling data from access 2003
Running windoes 2003 server

Table Name=Results
Field Names=Greeted, Friendly, ShelvesClean, FreshCoffee

Those field names are broken down into 3 categories, which are no where specefied on the database; however, they are broken down for reporting reasons...they are as follows:

Customer Service: contains Greeted and Friendly
InsideAppearance: contains ShelvesClean and FreshCoffee
TotalScore: contains all the above for a total score

Now, on the website, users enter in their point scale from 0 to 4 per question, hit submit, and it oges into my Access Database.

Ok, now, here is my question. I want to display the average for Customer Service, Inside Appearance, Total Score, AND the individual values for the evaluation in the SAME row of data. Meaning, I want it to look something like this:

Greeted: 4
Friendly: 3
Customer Service: 3.5 (avg of 2 above)
ShelvesClean: 4
FreshCoffee: 0
Inside Appearance: 2 (avg of 2 above)
Total Score: 2.75 (avg of Greeted, Friendly, ShelvesClean, and FreshCoffee)

I am able to get the averages for the WHOLE table, or by SPECEFIC evaluations (data not listed above); however, i am unable to simply list the averages / scores for each evaluation in a table format. Can anyone help me with the logic / code to achieve this? Thanks!!

dzirkelb
Yak Posting Veteran

53 Posts

Posted - 2004-08-12 : 11:23:59

Uhhh...nevermind, its really easy :)