NEED HELP WRITING QUERY

S

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.
 
L

LeAnne

Something like:

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

hth,

LeAnne
 
Top