Simple criteria question

  • Thread starter Thread starter miss031
  • Start date Start date
M

miss031

I am not too good at writing SQL, and I don't know how to do this in design
view: I would like the results of my query to be equal to ([this] AND
[that]) OR [the_other_thing]. I don't know the correct sytnax - please help!
 
Just type your expression (including the brackets) into the Criteria row
under the field that you wish apply the criteria to, i.e.
([this] AND [that]) OR [the_other_thing]

I'm not sure I understand your goals here.
There cannot be any value that will meet the criterion:
([this] AND [that])
i.e. if it's this, it cannot be that at the same time.
Therefore your criteria will return only records that contain
the_other_thing.
 
To clarifiy:
I have a multiple table query and I would like to find records that:
match [contact_ID] where [sale_current] = True
OR that match [contact_ID] where [is_perm] = True

Allen Browne said:
Just type your expression (including the brackets) into the Criteria row
under the field that you wish apply the criteria to, i.e.
([this] AND [that]) OR [the_other_thing]

I'm not sure I understand your goals here.
There cannot be any value that will meet the criterion:
([this] AND [that])
i.e. if it's this, it cannot be that at the same time.
Therefore your criteria will return only records that contain
the_other_thing.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

miss031 said:
I am not too good at writing SQL, and I don't know how to do this in design
view: I would like the results of my query to be equal to ([this] AND
[that]) OR [the_other_thing]. I don't know the correct sytnax - please
help!
Click to expand...
Click to expand...
 
Presumably [sale_current] and [is_perm] are Yes/No fields.

In query design, in the Criteria row under [sale_current], enter:
True

Below the Criteria row is one with OR at the left.
On this row, under [is_perm], enter:
True

I'm not sure if you want to further restrict the query to only these with a
particular [contact_ID]. If so, enter the number your contract number on
*both* rows under the [Contract_ID] field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

miss031 said:
To clarifiy:
I have a multiple table query and I would like to find records that:
match [contact_ID] where [sale_current] = True
OR that match [contact_ID] where [is_perm] = True

Allen Browne said:
Just type your expression (including the brackets) into the Criteria row
under the field that you wish apply the criteria to, i.e.
([this] AND [that]) OR [the_other_thing]

I'm not sure I understand your goals here.
There cannot be any value that will meet the criterion:
([this] AND [that])
i.e. if it's this, it cannot be that at the same time.
Therefore your criteria will return only records that contain
the_other_thing.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

miss031 said:
I am not too good at writing SQL, and I don't know how to do this in
design
view: I would like the results of my query to be equal to ([this] AND
[that]) OR [the_other_thing]. I don't know the correct sytnax - please
help!
Click to expand...
Click to expand...
Click to expand...
 
SO exactly what I needed! Thanks for your quick responses!

Allen Browne said:
Presumably [sale_current] and [is_perm] are Yes/No fields.

In query design, in the Criteria row under [sale_current], enter:
True

Below the Criteria row is one with OR at the left.
On this row, under [is_perm], enter:
True

I'm not sure if you want to further restrict the query to only these with a
particular [contact_ID]. If so, enter the number your contract number on
*both* rows under the [Contract_ID] field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

miss031 said:
To clarifiy:
I have a multiple table query and I would like to find records that:
match [contact_ID] where [sale_current] = True
OR that match [contact_ID] where [is_perm] = True

Allen Browne said:
Just type your expression (including the brackets) into the Criteria row
under the field that you wish apply the criteria to, i.e.
([this] AND [that]) OR [the_other_thing]

I'm not sure I understand your goals here.
There cannot be any value that will meet the criterion:
([this] AND [that])
i.e. if it's this, it cannot be that at the same time.
Therefore your criteria will return only records that contain
the_other_thing.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

I am not too good at writing SQL, and I don't know how to do this in
design
view: I would like the results of my query to be equal to ([this] AND
[that]) OR [the_other_thing]. I don't know the correct sytnax - please
help!
Click to expand...
Click to expand...
Click to expand...
 
Back
Top