hi,

<='Resolved'

cannot work, i'd guess. I would suggest that you first test your sql-string
as plain text without any concatenating, variables etc.

regards

arno

"WHERE
(HPD_HelpDesk.Status<='Resolved') AND (HPD_HelpDesk.Base= 'ABNY')" &
Chr(13) & "" & Chr(10)