grouping in a report

[Smev]

I would like to know if it is possible to group a report on two fields of a form. The form is based on a query. I have several questions with multiply answers. Each answer is given a score and that score is applied to the record. Each record is grouped according to the score which worked well on the report. Now an alternate score is produced for each record and based on the same grouping. Is there a way to have the record show up in two different groups on the report according to the two different scores that are stored in seperate fields.?

 

[llkhoutx]

Checkout "View/Sorting and Grouping" when you have your report open in the design view.

 

[Smev]

I had used the Sorting and Grouping to do the original report. This did not work for what I needed for the new report. I needed to put each record into two groups or one group baised on the results of two fields. The way that I had to do it was create a query for each group that OR'd the two fields and then make a report for each group. I was looking for a quick and easy way out.