grouping levels using queries

[Red via AccessMonster.com]

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]

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 via AccessMonster.com]

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