f = “UserName, ProjectName, TimesheetDate, TimesheetLocation, PerDiemDesc, TimesheetPerDiem, TimesheetLodging, " _
& "TimesheetMeals, TimesheetMileageAmount, TimesheetMileagePerMile, " _
& "TimesheetMileagePerMile*TimesheetMileageAmount, " _
& "TimesheetPhone, TimesheetCopies, TimesheetMisc, TimesheetPerDiem”
o = "TimesheetDate, TimesheetLocation, ProjectName"
w = "UserID = " & FormatForSQL(rUser(1),"L") & sWHERE
q = SQLSelectQuery(f, "tblTimesheet", sJOIN, w,
2006-10-06
15:05:14
·
5 answers
·
asked by
Anonymous
in
Computers & Internet
➔ Programming & Design
o)
Set rDetail = oConnection.Execute(q)
2006-10-06
15:08:44 ·
update #1