Need help Grouping and Sorting in report

[JP]

I have a query that returns data similar to below

Model Num Year Sales
111 2005 300
222 2005 400
333 2005 500
111 2006 300
222 2006 400
333 2006 500


I need my report to show data as follows sorted by sales in descending order

Model Num Year Sales

333
2005 500
2006 500

222
2005 400
2006 400

 

[John Spencer MVP]

Open your report in design view
Select View: Sorting and Grouping from the menu

Enter MODEL Num in the first row of the dialog
Set Group Header to Yes
Enter Year in the next row
Close the Sorting and Grouping dialog

In design mode, drag the Model Num control up into the group header you have
just created.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Missy]

Similar to this initial ?, how could I make the data look like the following:

A list across the page instead of down the page (for lack of a better
description)
THANKS!