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

Want More?

Office Watch has the latest news and tips about Microsoft Office.  Delivered once a week.