Multiple rows in query show in the one report entry

[Deleted member 134417]

Hey guys,
First up i'm very new to Access and this is the first time I've dipped my toe into the water of reports!
I have a query that returns numerous rows of data per person per day.
Simplified Example ( ';' used to show columns):

LastName ; Date ; DrillNumber ; Score
Smith ; 18/9/14 ; 0 ; 100
Smith ; 18/9/14 ; 1 ; 150
Smith ; 18/9/14 ; 2 ; 120
Doe ; 18/9/14 ; 0 ; 150
Doe ; 18/9/14 ; 1 ; 150
Doe ; 18/9/14 ; 2 ; 100
etc.

I'm trying to create a report that shows each of the scores per drill in the report per person (Dont worry about the formatting):
Name: Smith
Date: 18/9/14
Drill & Score:
0 - 100
1 - 150
2 - 120

However, when I drag the field lists into the report Im getting a new report entry for each drill eg.

Smith
18/9/14
0 - 100

Smith
18/9/14
1 - 150
etc.

Can you help me with a way to get all drills to show in the one report entry per person? So all data for Smith is in the one report or report section, and then all the data for Doe.

I'm also looking for a way to specify the date and it will only fill the report for that date rather than make reports for every date listed in my query, but i'll post that question in a new thread once I get this sorted out.
Thanks in advance

 

[JHB]

You can group your data in the report, below is a link which shows you how you do it and a lot of other good stuff creating a report.
http://office.microsoft.com/en-us/access-help/create-a-grouped-or-summary-report-HA010006894.aspx

 

[Deleted member 134417]

Thanks JHB, ill have a look at get back to you with any more questions.
One thing though, I stumbled onto grouping myself and was able to group the data, but i was having trouble with putting headings for what the data is.
Example I got it to group the way I wanted to - showing the score of 100, 150, 120 etc on the one report section. But i am wondering is there a way to put the heading 'Score' in the report and only have it show above the top of the score group and not after every entered score? So it reads like:
Score ;
100 ;
150 ;
120 ;
And have it repeat like this for each person?

because at the moment it reads like this:
Score ;
100 ;
Score ;
150 ;
Score ;
120 ;

 

[JHB]

Yes it is, put it in the group header like shown in the link I attached.

 

[Deleted member 134417]

Thanks JHB, I think i was doing to many groups at once. All working good now, cheers

 

[JHB]

Good you got it solved.