data environment and between sql statement?

[Bebe]

I was wondering if anyone could help me with the syntax for the following query I need to perform:

I have a field in my data base called DATE_OPENED.

I need to make a sql statement that has the number of DATE_OPENED for the month or March.

I have SELECT COUNT(*) AS MarchReceived FROM MASTER WHERE (DATE_OPENED <>'"')

However, I need to get only the records from March that have something in the DATE_OPENED field. I'm thinking I need the between statement 3/1/00 and 3/31/00 but not sure how to use all of this in one statement or the correct syntax.

Any help would be great!!!

[bsmith]

You should be able to do something like this:

SELECT COUNT(*) AS MarchReceived
FROM MASTER
WHERE DATE_OPENED >= "03/01/2000" and
DATE_OPENED <= "03/31/2000" and

[CRACK]

or try this one:

SELECT COUNT(*) AS MarchReceived
FROM MASTER
WHERE DATE_OPENED between "03/01/2000" and "03/31/2000" and