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 “connects criteria in different rows with OR, and finds records that meet the criteria for the first or second row of the design grid.”
If this is the case why do I get incorrect results? specifically for rows where only 2 parms are specified?
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 “connects criteria in different rows with OR, and finds records that meet the criteria for the first or second row of the design grid.”
If this is the case why do I get incorrect results? specifically for rows where only 2 parms are specified?
