NEED HELP WRITING QUERY

[S. Jackson]

I want to write a query that will give me all the new files opened during
the month. I have a field that contains the date the file was opened. How
do I write the code needed in the query to only return files opened during
the current month? Thanks in advance.

Shelly J.

 

[LeAnne]

Something like:

SELECT <yourfields>
FROM <YourTable>
WHERE Month([DateOpened])=Month(Date());

hth,

LeAnne