Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / May 2006

Tip: Looking for answers? Try searching our database.

grouping levels using queries

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Red - 22 May 2006 15:59 GMT
Good afternoon,
I have a query that returns multiple results i.e. question 1 and a score of 1

question 1 and a score of 1

question 1 and a score of 1

question 1 and a score of 1

question 2 and a score of 1

question 2 and a score of 1

question 2 and a score of 1

question 2 and a score of 1

question 3 and a score of 1

question 3 and a score of 1

question 3 and a score of 1

question 3 and a score of 1
Etc...

What I THINK (I could be wrong) I want to do is creat another query that will
group the results into something like this:

Question 1 answered 4 times with a total score of 4

Question 2 answered 4 times with a total score of 4

Question 3 answered 4 times with a total score of 4

Is this at all possible?  I want to export the results of this new query to
excel.  Any help would be greatly appreciated.  Hope I have enclosed enough
information.

Thanks in advance for any advice given.

Red
Jeff L - 22 May 2006 16:25 GMT
How is your data stored?  What are the fields you are using?  Is there
are Question Field and a Score Field?  Is "question 1 and a score of 1"
stored in a field this way or did you create the text somehow?  More
info needed please.
Red - 22 May 2006 16:49 GMT
He Jeff,
The fields are stored in fields called Question and Value.  I'm sorry, I just
made up the txt the query pulls it as question & value I thought just leaving
it as that would be confusing but it looks like I created confusion :<(
Sorry.  Do you need any more information?  I've got to go now but will return
here tomorrow.  Thanks for your help.
Red

>How is your data stored?  What are the fields you are using?  Is there
>are Question Field and a Score Field?  Is "question 1 and a score of 1"
>stored in a field this way or did you create the text somehow?  More
>info needed please.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.