Perameter Query to select only current month

[tpeter]

I have a perameter query that tracks everyone's time on different projects. When they click on the command button to run the query they are asked for the current start data and end date (this is loaded into the date field within the query on the criteria cell). When they click on this query I would like them to only be able to view the current month instead of any date range. The query is set up on a short date format and I have tried some diffent combinations but can't figure out exactly what to put into the criteria. Any help would be great.

Tim

 

[pbaldy]

WHERE Month(DateField) = Month(Date()) AND Year(DateField) = Year(Date())

Where DateField is the name of your date field.

 

[tpeter]

WHERE Month(DateField) = Month(Date()) AND Year(DateField) = Year(Date())

Where DateField is the name of your date field.

This information is typed directly into the criteria cell of the query?

 

[pbaldy]

No that's the actual SQL. Let's see, maybe this will be easier for you. Put this in the criteria of the date field:

Between DateSerial(Year(Date()),Month(Date()),1) And DateSerial(Year(Date()),Month(Date())+1,0)

 

[tpeter]

Thanks Paul, I haven't had a chance to load it in but I really appreciate your help and quick responce.

Tim

 

[raskew]

Hi -

Take a look at this example http://www.access-programmers.co.uk/forums/showthread.php?t=124029 that only requires the user to enter mm/yyyy (e.g. 03/2007) to return all records from the specified month.

Bob