Heres's my problem. I need to create a report that has information drawn from 2 tables. Since I can not create a datareport based on 2 seperate datasources, I need to extract the information from the 2 tables and place the information in a single table. I can use a select into statement to do this, right? Or is there a way I can create a datareport with 2 different datasources? If not then continue to read. My 2 tables will reside on a common file sharing computer. The table I want to create will reside on the individual's computer who is running the report. After the report is run the table will be deleted. When I run the select into statement, the new table is created in the database of the 2 tables that reside on the common computer. Can the select into statement be made to create the table on the individual's computer? Is there an easier way to do this?
Thanks
Todd