Count dates no matter what year

[seashore67]

I'm attempting to make a count query of different groups of months. For example, July 1st thru Sept 30th. How can I do this without putting in a year for the query.

Thanks
Andrew

 

[Golom]

[tt]
Select Month(myDateField), Count(*) As NumberOfRecords
From tbl
Group By Month(myDateField)
[/tt]

 

[seashore67]

Thank you for your help. Works marvelously!

Andrew

 

[seashore67]

I have another question though. Is it possible to pop up a message box of some sort to ask the user what year?

Thanks again,
Andrew

 

[Golom]

Sure
[tt]
Select Month(myDateField), Count(*) As NumberOfRecords
From tbl
Where Year(myDateField) = [Enter the Year]
Group By Month(myDateField)
[/tt]

 

[seashore67]

Thank you again.
Andrew