View The SQL statement of a report??

Dear All;
Does anyone know how to find the SQL statement of a report? i have a report written by another use, i can see from the field list list box title some of the SQL, but i want to see it all? its not in the queries nor the tables. Can anyone help me with that?

Another question: how can i insert some data from one database into another one, one answer was to use an INSERT TO statement, but how can i use it to access one table in one database, into another table in another database?

Thnx in advance,

Assume thsi is an Access report, you just have to go into the report in design mode, then go
View - Properties, then choose the data tab, and you can then see the record source.
In regard to using an insert satment, just create a linked table to the databse you want to use the insert stament on. You can then treat the linked table as you would a local one.