REcords between certain dates

[stenman]

Need help to select records that should be shown depending on day and month. For example the records that are taking place between 1.9 to 11.9 each year. I dont know how to exclude the year from my query and therfore it is not working as I would like it to work!

[JoeM]

Assuming your Date Field is in a Date Format/Datatype, you can use criteria something like this:

WHERE (Month([DateField]) = 9)
AND (Day([DateField]) Between 1 and 11)

[stenman]

thanks that solved it.....