Hi guys,

I am back with another problem: I have taken over an access model which was designed by someone else. The thing is there is a report which is based on many sub-reports. The problem I am running into is that there is a year code embedded somewhere and I am not sure where it is. So I want to update it to 2011 and also get the report populated with 2011 data. When I am running the report it gives an error sign for 2011 but is okay when I put 2010. This is what I have in the control source:
"Income Statement Summary DETAIL (Consolidated "+Forms!main.selectbook+" Book) - "+IIf(Forms!main.BegDate=Forms!main.EndDate,Format (Forms!main.EndDate,"mm/yyyy"),Format(Forms!main.BegDate,"mm/yyyy")+" thru "+Format(Forms!main.EndDate,"mm/yyyy"))

Please advise.

Thanks a lot.



Indira