Group By Yes/No In Report Question

  • Thread starter Thread starter NFL
  • Start date Start date
N

NFL

Is there a way that I can group reports by conditions? I would like to group
my report based on what is completed and what is not completed. Every record
has an option to check yes or no. The checkboxes would be used for (if
completed.. then check yes --- if not completed then check no)

Thank you!
 
Just create a group in the sorting/grouping on that field.
Create a Group Header for it.
Since True = -1 and False = 0, Records with False will be grouped first. If
you want the Trues to be first, set the grouping options to sort descending.
 
Thank you!

Klatuu said:
Just create a group in the sorting/grouping on that field.
Create a Group Header for it.
Since True = -1 and False = 0, Records with False will be grouped first. If
you want the Trues to be first, set the grouping options to sort descending.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding a checkbox to an Access 2007 report 1
grouping based on checkboxes 1
Yes/No checkboxes 2
yes/no checkboxes 3
very slow report with dcount() 6
Access Dcount (multiple criteria) 3
Calculating percentage from grouped report 3
Display graphical check for completed tasks 1

Back
Top