2010 Report Grouping Help

[AccessInMicrosoft2010]

Hello!



I have taken classes in Microsoft Office 2010, however, I still need help understanding how to print out select groups from a Microsoft Access 2010 report. Also, I am wondering if there is a way to sort the rows in each respective group according to personal preference? (e.g. "a", "m", "b", etcetera instead of "a", "b", "c")

Thank you! I hope that this made sense!

[burrina]

Sure, take a look at these links. http://office.microsoft.com/en-us/ac...010341571.aspx
http://www.youtube.com/watch?v=KwX0xovCUwo
http://allenbrowne.com/ser-33.html

HTH

[AccessInMicrosoft2010]

Thank you burrina for trying to help. Unfortunately, I looked through the links and found that none of them answered my question (except for the last link; that link contains programming and I am unable to program, so this is not helpful to me, unfortunately). I am wondering if I could possibly get a straight-to-the-point answer to my question from anyone who is able?

Thank you all so much! I really appreciate everyone's help

[ItsMe]

...I am wondering if there is a way to sort the rows in each respective group according to personal preference?...

Open the report in design view and adjust the sort order properties of your Groups via the Grouping Dialog Box.

[AccessInMicrosoft2010]

Open the report in design view and adjust the sort order properties of your Groups via the Grouping Dialog Box.

How do I find the Grouping Dialog Box? I know where the Group, Sort, and Total box is. Is that what you mean? In the Group, Sort, and Total box, the only sorting option that I see is from A or from Z. How do I customize it so that it starts with "M" and then goes to "A" and then goes to "D" and etcetera? Thanks again so much!!!

[ItsMe]

You could create some alias' in a separate query object.

Field1_ AtoD: Table1.Field1
Field1_ EtoH: Table1.Field1
Field1_ ItoL: Table1.Field1

Then, add the query you created to a second query object, adding the alias' to the grid. In each of the alias' criteria you could type
Between 'A' AND 'D'
Between 'E' AND 'H'
Between 'I' AND 'L'
respectively

making sure to skip to the next grid line below for each alias, ensuring the OR operator is included in your WHERE clause vs. using the AND operator

Use the second query as your Report's Recordsource and group on
Field1_ AtoD
Field1_ EtoH
etc.

maybe

[June7]

Sorting requires a field with values to define sort order. Can't directly force an order like "a m b". Would need code or a table of equivalents to convert: a = 1, m = 2, b = 3. Then sort by the numeric equivalents.

I think ItsMe may have been referring to the report Sorting & Grouping features. Open report in Design view, right click on any section bar, select Sorting & Grouping. Should open a work area at bottom of the app window below the report.

What are the 'select groups' you want to specify?