I have a table with the field "Enddate". I want to get a list of records of the 12 months. In every month i want to see the records where the enddate is bigger than that month. So Access has to look to the month in the date and sort the records by motn 1,2,3 etc. For example january has 30 records that are not ended.
Can somebody help please!

What was wrong with the answer you where given yesterday? If you didn't understand the reply or it wasn't what you had in mind then please continue with that thread.