SQL Statement \ Crystal Report

[StevenH]

In order to display the results of a uery onto a Crystal report, I conduct he query and the results of the query are placed into a temp.mdb

On my report I have two tables...

Here is my sql statement:

db.Execute "SELECT * INTO STEVE IN '" & strTempDb & "' FROM TEst1 " & _
"WHERE StartDate >= #" & Format(datDate3, "mm/dd/yyyy") & "# " & _
"AND EndDate <= #" & Format(datDate4, "mm/dd/yyyy") & "#"


This will take the result and place it into a temp db
I want to be able toadd a second statement ...
I want the temp db to create two tables...

Is this possible or can I just add a nother sql statement?

Please respond...


Very Urgent

Steve

[paulw]

Steve,

You can pretty much do what you want. You could create another table in tempdb or add data to the existing table.

You seem au fait with SQL so just use another SQL statement to create data in STEVE1, say.

If I have misunderstood the problem then get back to me.

Cheers,

Paul.