Calculating using current date

[ladydazy]

Hmm, I've been wondering and experimenting...
How does one list all activities within the last month (and the month would be the current month, whenever the current month is) from a table such as:

tblActivity
activityid
activityname
startdate
enddate

I tried using the TODAY () function in an SQL query and Access said there was an undefined function (TODAY() ) in the statement.

 

[AN60]

I use this in a query when I want to view data for the current month;
Between DateSerial(Year(Date()),Month(Date()),1) And Date()