Grouping in reports (1 Viewer)

eacollie

Registered User.
Local time
Today, 14:50
Joined
May 14, 2011
Messages
159
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

Wino Moderator
Staff member
Local time
Today, 14:50
Joined
Aug 30, 2003
Messages
36,118
There's a group and sort icon on the ribbon with the report in design view.
 

eacollie

Registered User.
Local time
Today, 14:50
Joined
May 14, 2011
Messages
159
Thanks. Saw that but not sure how to get into the format:

Commuters:
Person1
Person2
Non-Commuters:
Person3
Person4
Person5
 

June7

AWF VIP
Local time
Today, 13:50
Joined
Mar 9, 2014
Messages
5,423
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

Registered User.
Local time
Today, 14:50
Joined
May 14, 2011
Messages
159
Thank you. Where do I put the headers "Commuter" and "Non-Commuter"?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 14:50
Joined
Aug 30, 2003
Messages
36,118
I'll get out of the way.
 

June7

AWF VIP
Local time
Today, 13:50
Joined
Mar 9, 2014
Messages
5,423
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")
 
Last edited:

Users who are viewing this thread

Top Bottom