Dear Friends
I have a table with a "Date" field. In the queiry, I have grouped it into 6 monthly. Although it is easy to group the date in Quarterly, I do not find ready made expression for 6 monthly. So I have used the following expression:
6Monthly: IIf([Date]<#1/1/2008#,"1stSixMonth",IIf([Date]<#7/1/2008#,"2ndSixMonth",IIf([Date]<#1/1/2009#,"3rdSixMonth",IIf([Date]<#7/1/2009#,"4thSixMonth","5thSixMonth"))))
You may notice that the above expression is quite limited. It can only group the date between 6/1/2007 to 12/31/2009. If I want to make it further qrouping, I need to modify the experssion.
Here, my question is "is there more decent VBA code for this stuff?". I want to start from 6/1/2007 onward.
Thank in advance
I have a table with a "Date" field. In the queiry, I have grouped it into 6 monthly. Although it is easy to group the date in Quarterly, I do not find ready made expression for 6 monthly. So I have used the following expression:
6Monthly: IIf([Date]<#1/1/2008#,"1stSixMonth",IIf([Date]<#7/1/2008#,"2ndSixMonth",IIf([Date]<#1/1/2009#,"3rdSixMonth",IIf([Date]<#7/1/2009#,"4thSixMonth","5thSixMonth"))))
You may notice that the above expression is quite limited. It can only group the date between 6/1/2007 to 12/31/2009. If I want to make it further qrouping, I need to modify the experssion.
Here, my question is "is there more decent VBA code for this stuff?". I want to start from 6/1/2007 onward.

Thank in advance