The 1st of each month I have to do a report that showes the number of cases closed the previous month and I have the following criteria in my query in my date entered field: >=DateSerial(Year(Date()),Month(Date())-1,1) And <DateSerial(Year(Date()),Month(Date()),1). This gives me all cases closed the previous month (for March it would show me all cases closed for Feburary).
I also have to track all the cases from 1-1-06 to the month prior to the previous month mentioned above, January in this case. For March my report needs to show all cases closed from 1-1-06 to 1-31-07. I would like to automate this so that my query knows to look for all cases from 1-1-06 upto and including the the month prior to the previous month of my report.
I also have to track all the cases from 1-1-06 to the month prior to the previous month mentioned above, January in this case. For March my report needs to show all cases closed from 1-1-06 to 1-31-07. I would like to automate this so that my query knows to look for all cases from 1-1-06 upto and including the the month prior to the previous month of my report.
