Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Thanked 0 Times in 0 Posts

    OR expression help (97)

    OR expression help

    I setup a query to receive multiple criteria against at least one of 3 fields.

    My criteria are the name of controls on a form, 3 controls total.

    I specified different combinations of my criteria (controls) in the query grid, 7 rows total.
    In 3 rows, I specified a combination of 2 of the controls only. The 4th row has all 3 parms included and the last 3 rows have a single parm, one for each field.

    Access says it

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: OR expression help (97)

    You would have to post the SQL (which sounds ugly) to get a definitive answer, but the usual reason for this is that you have forgotten that *all* of *each* row is a single "and" statement. That means that conditions in one row may be overridden by conditions in another row. Keep in mind that if you don't specify a criteria in one of the lines, that means that when the other conditions in that row are met, all values in the other fields are acceptable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts