SELECT causing error - any idea why?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've been stuck on this for almost a full day, the following select generates
an error number zero.

Dim rs As New ADODB.Recordset
....
strSQL = "SELECT MIN(When) As MW FROM tblNotEmailed WHERE Agent = '" &
NTUserID & "'"
rs.Open strSQL, CurrentProject.Connection, adOpenForwardOnly, adLockReadOnly

'When' is a date/time column, is this the problem? The sql runs fine when I
run it as a query.
 
Back
Top