GROUP BY and ORDER BY in same query?

[MarcieFess]

Hello all.

I have a query that must ORDER BY Aisle_Number

I have 2 other fields that must GROUP BY for a report.

The report calls the query.

One field, tblStoreProduct.Storage, can be either "I" or "C". The report must start a new page for "I" and "C" in the same aisle.

Another field, tblStoreProduct.Use, can be "S", "O", or "C". The report must ALSO start a new page for each Use within each Storage within each Aisle.

Is this possible to do?

 

[Alansidman]

Marcie;
Look at this link and in particular the grouping and sorting video in the reports section. Really good stuff here. You may want to review other videos as they may be helpful as you progress up this curve we call Access.

http://www.datapigtechnologies.com/AccessMain.htm