Hi there,<BR><BR>I'm having an issue. I have an SQL query which works when run within ACCESS itself (returns plenty of records) but when run through ASP it returns no records. This is the part of the SQL query which makes the difference:<BR><BR>WHERE CCB.Date_Completed=NULL<BR><BR>When I remove this from the ASP code, the query returns plenty of records, but not the correct ones. When I leave that in the ASP code, rs.BOF is always true. Yet, when I copy/paste the SQL into MS Access and execute the query, I get the result set I'm expecting.<BR><BR>Can anyone lend any insight?<BR><BR>Thanks!