Quote Originally Posted by 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.
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