NEED HELP WRITING QUERY

  • Thread starter Thread starter S. Jackson
  • Start date Start date
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.
 
Something like:

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

hth,

LeAnne
 
Back
Top