SQL Query to return specified test numbers and date

Question

I have a table with a TestNumber column with four possibilites (ex: 1 - 4), a TestDate column, and other data. I want to make a query that will return a user defined year and test numbers. For example, I want to return test Numbers 1 and 2 that have a date with year 2008.

Edit: I basically want to combine these two statements into one statement:

SELECT * FROM testTable WHERE testNumber = '1' AND '2'
SELECT * FROM testTable WHERE testDate between #01/01/2008# and #01/01/2009#

Answer 1

Try this:

SELECT * 
FROM testTable 
WHERE testNumber IN ('1', '2') 
    AND testDate between #01/01/2008# and #01/01/2009#

Answer 2

I'm not sure anyone has answered this correctly yet. @Manu combines the criteria, instead of the result sets, so he won't get the UNION of the questioners two SQL statements. It seems to me, it should be:

  SELECT * FROM testTable WHERE testNumber In ('1', '2') 
     OR testDate between #01/01/2008# and #12/31/2008#

Note that some database engines (including Jet/ACE) interpret the values of a BETWEEN/AND pair inclusively, so the criteria ought to be the first and last dates of the year, rather than Jan. 1st of the two years.

But that will actually depend on the particular db engine's interpretation of BETWEEN/AND.

Note also that if the date fields have time parts, you'll need to use:

  testDate >= #01/01/2008# and testDate < #01/01/2009#

...instead of BETWEEN/AND.