Re: Design View Criteria question

On Fri, 13 Apr 2007 11:42:31 GMT, "archico01" <u33274@uwe> wrote:

In design view of a query, what will be the output difference in the
following photos? What will happen to the data if I put the other criteria in
the "Or" column? Please click link. Thanks a lot guys!

http://i33.photobucket.com/albums/d98/archico01/qry.jpg
http://i33.photobucket.com/albums/d98/archico01/qry2.jpg

The first query will use AND logic: it will return those records for which the
first field is equal to 123, and (in the same record) the second field is
equal to 456.

The second query will use OR logic: it will return those records for which the
first field is equal to 123 (regardless of the value in the second field), as
well as all those records where the second field is equal to 456 (regardless
of the value in the first field).

Boolean Algebra is a wonderfully powerful but not necessarily intuitive
mindset. I owe Coach Clell Burnett, Bentonville High School, 1963 a lot of
credit for introducing me to the concept; and it's absolutely at the basis of
query design.

True AND True = True
True AND False = False
False AND True = False
False AND False = False

True OR True = True
True OR False = True
False OR True = True
False OR False = False

John W. Vinson [MVP]
.

Relevant Pages

  • Re: Group by (Selecting First) after Sorting
    ... You posted in the tablesdbdesign newsgroup. ... If you want a query that sorts by the first field, ... ascending order on the second field, which gives, ...
    (microsoft.public.access.tablesdbdesign)
  • RE: IIf comparison
    ... How would I link this query to the report? ... > Qreate a query with the following equation ... >> where if the first field is greater in value than the second field, ... But if the first field is less in value ...
    (microsoft.public.access.reports)
  • Re: dpkg -l postfix
    ... Every field of this tabular output has a caption. ... The first field is set to "i", so according to the caption, the desired ... action that dpkg sees for this package is "Install". ... The second field is set to "i", which means the current status is ...
    (Ubuntu)
  • Re: Question on how relationships work
    ... Bill, you say "the user does not even see the first field ... ... I have a value list for a drop down field, with OrgID as first value, and OrgName as second value, with only OrgName visible - so far so good. ... I gave you an answer in your other thread, suggesting that you use a drop-down list, with the Person ID number being the first field, and the calculated NameLastFirstSuffix as the second field and the only field visible to the user. ...
    (comp.databases.filemaker)
  • Re: Question on how relationships work
    ... The user does not even see the first field that is ... and the second field is sorted alphbetically. ... You seem determined to avoid this approach as being too cumbersome. ... visible field. ...
    (comp.databases.filemaker)