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!
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!