Hello



I have a variance report in access which it's working. But i'm missing one part. The report is by Provider, year and month. For March i have this =+[R_Gross A/R Ending Balance subreport].Report.March/((R_RheumVarianceTotalCharges.Report.January+R_Rhe umVarianceTotalCharges.Report.February+R_RheumVari anceTotalCharges.Report.March)/90), which gives me how many gross days are outstanding in A/R. This is where i need help, I'm not sure how to get the formula for January and February. The reason is because i would need to pull the numbers from prior year. For January i would need to pull numbers from November 2011, December 2011 and January 2012. How can i go about this????


Thank You