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/y18...rojectdata.jpg ( report sample document)

http://i5.photobucket.com/albums/y18...etionship4.jpg

(database tables)

its not particularly complex... you just need to understand how the data builds up into your report.

Now then, looking at the report sample, it would appear you want to report "The hours worked on each project by each employee"... I could give you the sql for this, but I think you would be better off (since this isnt complex at all) doing it yourself.

Here is how... open a query and then add the Hours Worked table. Click the "Totals" (sigma sign, spikey E symbol!) button... then simply add Employee, Project and Hours. You then need to set the "Total" option to Group for those you want to group and Sum for those you want to add up, ie: Hours.

Once you have the base query working how you want it to work, simply add in any other tables or fields you would like, but ensure any additional tables and fields are not going to "dis-aggregate" your groups.

This isnt complex in the slightest, assuming you know your data the best way to achieve this, imho, is to play with the group function for a while to get a feel for it.

Looks like you want the Task level grouping, so along with the Employee and Project, add in Task from your Hours Worked table too... this will add a further level of detail to the task level.