VB Code:
strSQL = "SELECT Expenses.EmpID,Expenses.ExpID, Expenses.Date_Incurred, "
strSQL = strSQL & "Expenses.RateID, Rates.Description, Expenses.Mileage, "
strSQL = strSQL & "Expenses.Total_Cost "
strSQL = strSQL & "FROM Expenses INNER JOIN Rates ON Expenses.RateID = Rates.RateID "
strSQL = strSQL & "WHERE EmpID = " & empExp & "
strSQL = strSQL & "AND datefield BETWEEN #startdate# AND #enddate# "
cmdComm.ActiveConnection = conConnect
cmdComm.CommandText = strSQL'etc
How you would encapsulate your two dates would depend on the DB field types (i.e., depending on whether your date field is text or date/time)