Show all dates within September for current year

[sdjames1979]

Hi

I need the criteria to show any dates within September of the current year, i.e. today should show all September dates in 2015, when I run the query in 5 years time, it should show all September 2020 dates.

Thanks

S

 

[Minty]

I have a bit of deja vu here, but if you run this in October do you still want September or would you want October for whatever year you are running it in...

Have a look at your previous thread http://www.access-programmers.co.uk/forums/showthread.php?t=281082 for some good clues.

 

[sdjames1979]

The previous thread was for 1st of the month (September) dates.

This question is for any date within September.

If run in October, November, December - it should only show ALL dates in September for the current year.

I will need to create 12 queries for each month, but once I know how to do the first, i'll be ok with the rest.

Thanks

S

 

[Minty]

You are approaching this from the wrong angle.
Create one query and have the dates entered from a form. You can use a date picker and can then run the query over any period your user wants.

 

[sdjames1979]

If only I knew what you were talking about! lol