It seems that the to complex expression error is generated by the format of opened to months. works perfect in 2000.

I can't use 2000 for the report unfortunaty. this department does not own it and is not willing to buy and want thier in house people to be able to generate the report.

Thanks for trying as hard as you did.