Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 08-19-2018, 10:08 AM   #1
eacollie
Newly Registered User
 
Join Date: May 2011
Posts: 152
Thanks: 23
Thanked 0 Times in 0 Posts
eacollie is on a distinguished road
Grouping in reports

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!

eacollie is offline   Reply With Quote
Old 08-19-2018, 10:36 AM   #2
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,032
Thanks: 10
Thanked 3,862 Times in 3,805 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Grouping in reports

There's a group and sort icon on the ribbon with the report in design view.
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
Old 08-19-2018, 10:40 AM   #3
eacollie
Newly Registered User
 
Join Date: May 2011
Posts: 152
Thanks: 23
Thanked 0 Times in 0 Posts
eacollie is on a distinguished road
Re: Grouping in reports

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

Commuters:
Person1
Person2
Non-Commuters:
Person3
Person4
Person5

eacollie is offline   Reply With Quote
Old 08-19-2018, 11:02 AM   #4
June7
Newly Registered User
 
Join Date: Mar 2014
Posts: 805
Thanks: 0
Thanked 182 Times in 182 Posts
June7 will become famous soon enough
Re: Grouping in reports

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.
__________________
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.
June7 is offline   Reply With Quote
Old 08-19-2018, 11:06 AM   #5
eacollie
Newly Registered User
 
Join Date: May 2011
Posts: 152
Thanks: 23
Thanked 0 Times in 0 Posts
eacollie is on a distinguished road
Re: Grouping in reports

Thank you. Where do I put the headers "Commuter" and "Non-Commuter"?
eacollie is offline   Reply With Quote
Old 08-19-2018, 11:06 AM   #6
pbaldy
Wino Moderator
 
pbaldy's Avatar
 
Join Date: Aug 2003
Location: Nevada, USA
Posts: 32,032
Thanks: 10
Thanked 3,862 Times in 3,805 Posts
pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold pbaldy is a splendid one to behold
Re: Grouping in reports

I'll get out of the way.
__________________
Paul
Microsoft Access MVP

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
pbaldy is online now   Reply With Quote
Old 08-19-2018, 11:13 AM   #7
June7
Newly Registered User
 
Join Date: Mar 2014
Posts: 805
Thanks: 0
Thanked 182 Times in 182 Posts
June7 will become famous soon enough
Re: Grouping in reports

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")

__________________
To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression. Attachment Manager is below Advanced editor window, click Go Advanced below Quick Reply window.

Last edited by June7; 08-19-2018 at 11:18 AM.
June7 is offline   Reply With Quote
The Following User Says Thank You to June7 For This Useful Post:
eacollie (08-19-2018)
Old 08-19-2018, 11:20 AM   #8
eacollie
Newly Registered User
 
Join Date: May 2011
Posts: 152
Thanks: 23
Thanked 0 Times in 0 Posts
eacollie is on a distinguished road
Re: Grouping in reports

Perfect! Thanks so much June7.

eacollie is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Grouping Reports Timko Reports 1 02-21-2005 09:13 AM
grouping in reports sadie Reports 2 12-23-2004 06:56 AM
Grouping in Reports lulonde Reports 1 04-07-2003 05:17 PM
grouping in reports piasalady Reports 2 03-06-2003 04:39 PM
Grouping in Reports Chineham Reports 3 04-15-2002 09:09 AM




All times are GMT -8. The time now is 11:28 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World