Grouping in reports

[eacollie]

Is it possible to group based on a value?

I have a list of individuals who are either "commuters" or not based on a room number. I want to display the "commuters" on this list followed by the "non-commuters." I've created a query behind the report and one field is "commuter" into which I've placed a "1" if the person is not a commuter and a "0" if the person is a commuter. I don't know how to group these separately on a report and need some help please.

Thanks!

 

[pbaldy]

There's a group and sort icon on the ribbon with the report in design view.

 

[eacollie]

Thanks. Saw that but not sure how to get into the format:

Commuters:
Person1
Person2
Non-Commuters:
Person3
Person4
Person5

 

[June7]

Create a group on the field that identifies commuter/noncommuter. Put that field into that group header section. Put Person info in Detail section. Try it and if you have an issue with that, post question.

 

[eacollie]

Thank you. Where do I put the headers "Commuter" and "Non-Commuter"?

 

[pbaldy]

I'll get out of the way.

 

[June7]

There is only one header for the one field that has the 0 and 1 data. If you want to display text then expression in textbox to convert 0 and 1 to the equivalent text.

=IIf([fieldname]=0, "Commuter", "Non-Commuter")

 

[eacollie]

Perfect! Thanks so much June7.