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)

[Hack]

You need to tell us what the query is supposed to do and what it is supposed to return.

Are you writing the query in SQL from VB and pass the recordset to Crystal?

Are you looking to write the entire query in Crystal using their scripting?

A lot more details need to be provided.

[tony007]

You need to tell us what the query is supposed to do and what it is supposed to return.

Are you writing the query in SQL from VB and pass the recordset to Crystal?

Are you looking to write the entire query in Crystal using their scripting?

A lot more details need to be provided.

Many Thanks to u reply. Well i want to create the query in access 2000 .The tables are in sql 2000 and i linked to those tables from access 2000.

I never used crystal report so i do not know if i can load a crystal report if i click on a command button from access 2000 form. Is there any advantage of designing and creating report in crystal report over using access create report feture? is it easier ? What is scripting feture of crystal doing ?

I want the query to return all the values that are in the listed document that i posted .Those values are not in one tables and i have diffculty creating such query to output all those field vaues in a new table. I be happy if some expert help me create this complex query .Thanks

[Hack]

If you are using Access, then stay with the Access report. There is no need for the expense or complexity of Crystal.

As far as building a recordset from multiple tables that isn't that difficult.I want the query to return all the values that are in the listed document that i posted . :confused: What document?

[tony007]

If you are using Access, then stay with the Access report. There is no need for the expense or complexity of Crystal.

As far as building a recordset from multiple tables that isn't that difficult. :confused: What document?

Thanks for u reply. I mean this document.

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