Filter SQL syntax for multiple parameters, please help!

[blakerrr]

Hi everyone,

Is it possible to write an SQL to filter for Field1 = A AND (Field2 OR Field 3) = B?

eg. Select * from TableName where Field1 Like A AND (Field2 Like B OR Field3 Like B)

If this is possible, pleeeease help me with the syntax!

Thanks!

[Rabbit]

Numbers:

SELECT *
FROM Table1
WHERE Field1 = 1 AND (Field2 = 2 OR Field3 = 3);
 

Strings:

SELECT *
FROM Table1
WHERE Field1 = 'A' AND (Field2 = 'B' OR Field3 = 'C');
 

Dates:

SELECT *
FROM Table1
WHERE Field1 = #1/1/2007# AND (Field2 = #2/2/2007# OR Field3 = #3/3/2007#);
 

[blakerrr]

Thanks Rabbit! much appreciated.

[Rabbit]

Thanks Rabbit! much appreciated.

Not a problem, good luck.