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,708
Thanks: 11
Thanked 4,000 Times in 3,938 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 offline   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
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,512
Thanks: 0
Thanked 367 Times in 366 Posts
June7 will become famous soon enough 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.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
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,708
Thanks: 11
Thanked 4,000 Times in 3,938 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 offline   Reply With Quote
Old 08-19-2018, 11:13 AM   #7
June7
Newly Registered User
 
June7's Avatar
 
Join Date: Mar 2014
Posts: 1,512
Thanks: 0
Thanked 367 Times in 366 Posts
June7 will become famous soon enough 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.
DEBUG! DEBUG! DEBUG!
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.

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 10:24 PM.


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

Featured Forum post


Sponsored Links


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