More on Filtering Reports by Month and Year
A reader offers some further information about the CreateMonthList function.
José Dumoulin wrote in response to the CreateMonthList function in the sample database for Access Archon #146:
For us, Europeans, it is necessary, in this line, to replace commas by semicolons:
strMonthList = strMonthMinus3 & ” ” & strYearMinus3 & “; ” _
& strMonthMinus2 & ” ” & strYearMinus2 & “; ” _
& strMonthMinus1 & ” ” & strYearMinus1 & “; ” _
& strMonth & ” ” & strYear
Office Watch has the latest news and tips about Microsoft Office. Delivered once a week.