View The SQL statement of a report??

[FiDz]

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,

[Oliver1]

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.