Date Query using SQL 1

[cyberprof]

I'm trying to query my Access database on my webiste to produce a report on data for a particular month. For example, how many people ordered so far this month, or how many people ordered last month.

Ideally I would like to say, show me all the data for August 2004, or all the data for July 2004, without having to worry about how many days are in each month, or whether its a leap year.

How do I write my SQL just to query a month. All I've done in the past is use the BETWEEN statement.

 

[spod]

SELECT date_id
FROM Table1
where month(date_id) = 8
and year(date_id) = 2004;

 

[cyberprof]

Nice one, thanks very much.

I'd almost worked it out for myself.

Cheers

J