AccessNewBoy
Registered User.
- Local time
- Today, 10:34
- Joined
- Mar 11, 2009
- Messages
- 19
Hi all,
i have an issue with a Query i have created which shows all birthdays within a 21 day period. I have searched this forum and it appears the problem has been experienced by other people to yet the solutions suggested to not rectify the issue do not. so i was wondering if anyone has any other thoughts.
The issue is that the Query is fine until it reaches the end of the calender year and it will not see January onwards until 2010 starts. For example as you know we are in December now and all it will show is Decembers Birthdays but will not role over an see any in January. I have tried the following ideas yet they have not made any difference:
Between Format(DateAdd("d",-1,Date()),"mm/dd") And Format(DateAdd("d",21,Date()),"mm/dd")
Between Date() and Date() + 21
I have attached the Database in question which contains my Query in case i am missing something silly but i have ran out of ideas, so any help would be appreciated.
i have an issue with a Query i have created which shows all birthdays within a 21 day period. I have searched this forum and it appears the problem has been experienced by other people to yet the solutions suggested to not rectify the issue do not. so i was wondering if anyone has any other thoughts.
The issue is that the Query is fine until it reaches the end of the calender year and it will not see January onwards until 2010 starts. For example as you know we are in December now and all it will show is Decembers Birthdays but will not role over an see any in January. I have tried the following ideas yet they have not made any difference:
Between Format(DateAdd("d",-1,Date()),"mm/dd") And Format(DateAdd("d",21,Date()),"mm/dd")
Between Date() and Date() + 21
I have attached the Database in question which contains my Query in case i am missing something silly but i have ran out of ideas, so any help would be appreciated.