Roll Call Documentation

Product Site

Popular Topics

Topics

  • Installing
  • Getting Started
  • Add People
  • Find People
  • Delete People
  • Manage Relationships
  • People Reports
  • People Export
  • Background Checks
  • Visitations
  • Communications
  • Groups
  • Group Reports
  • Events
  • Calendar
  • Check-in Setup
  • Computer Check-in Station
  • Tablet Check-in Station
  • Smart Phone Check-in Station
  • Fingervein Check-in
  • Record Attendance
  • Attendance Reports
  • Enter Contributions
  • Make Corrections - Contributions
  • Recurring Contributions
  • Contribution Receipts
  • Contribution Reports
  • Pledges
  • Directories
  • Tracks
  • Connect Administration
  • Set Up Connect
  • Staff Connect - Tablet
  • Staff Connect - Phone
  • Congregation Connect - Tablet
  • Congregation Connect - Phone
  • Query Editor
    • Query Editor Uses
    • Table Layouts
    • Sets
    • Current Selection
    • Basic Query
    • Complex Query
    • And, Or and Except
    • Save a Query
    • Special Query
  • Custom Reports
  • Data Administration
  • Database Maintenance

And, Or and Except

Created: 11/10/2017 • Updated: 11/10/2017


“Or” increases the possible results by allowing more ways for records to be selected. “And” restricts the possible results by compounding the requirements. “Except” restricts results by introducing exceptions or exemptions. If you need to use more than one of these conjunctions, place the OR statements first, then he AND statements, then the EXCEPT.


PREVIOUS
Complex Query
NEXT UP
Save a Query
Was this page helpful?
Roll Call is Created at By the book, Inc.
Facebook • Twitter • YouTube

Copyright © 2018 By the Book, Inc. All Rights Reserved.

Powered by Contentful