Nashat, you posted the following about historical inventory back in May 2007. Can you post it here again?
"Either run the last "select" statement alone, or use the attached RMS report, i had to make it in RMS report coz i felt that people r not happy using the query i prepared
thank you!