SELECT causing error - any idea why?

[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.

 

[Guest]

OK guys, I finally discovered 'When' is a reserved word.