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