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!!!