crystal report - changing the sql query text

Hi,

I am using VB6 and Crystal report for my application. While designing the report using report expert, I have used ADO with Jet 3.51 and for data I have an sql statement linking three tables from my Access database.

After designing the report, I am not able to modify the sql statement, if i want to add any more fields from the tables. When i try to modify the sql statement using verify command, i get an error message. As a result, if I want to modify my report adding some additional fields, I have to redo the entire design.

I am using CR8.

Can you help me where I am going wrong ???

thanx