Help need with designing this complex query

[tony007]

Hi every body. I am new to creating query and report. I got database and sample report document that i want to generate the report in access each week. My big diffuclty is how to design and create the query for this complex report so any help would be appreciated.I posted picture of my database tables with their reletions and sample report document below. The database is in sql server 2000 and i linked to those tables from access 2000. I be happy if some expert help me create this complex query for this report.Thanks



http://i5.photobucket.com/albums/y180/method007/weeklyprojectdata.jpg ( report sample document)

http://i5.photobucket.com/albums/y180/method007/sqlserverreletionship4.jpg

(database tables)