Hello

Tools:
Crystal Reports 4.6, VB 6.0 and Access 97

Table Name:
Expense
Times

Here is my sql statement for one table

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

Here I am querying records for those two dates that are entered... This is one table... I want to be able to add a second table to this statement.... where I am using different text boxes instead

The dates from each table are related.. I am trying to place the results into a TEMP.mdb and then my crystal report displays the data from that temp.mdb

Can anyone help me with my statement to search from two tables in the same db????



How can I add a third criteria to this statement

db.Execute "SELECT * INTO Times IN '" & strTempDb & "' FROM Times WHERE DatePerformed>=#" & Format(datDate3.Value, "dd/mm/yyyy") & "# AND DatePerformed<=#" & Format(datDate4.Value, "dd/mm/yyyy") & "#"


I want to add the field (ProjectCode) and the control )DataCombo1.text


Help is greatly appreciated!!!!

Steve