no. of records displayed by a query is different in MS Access & when i paste the same query in asp. why? <BR><BR>the query (for e.g. LeadAssgAmount3 is doing a left join on 2 other queries. it returns 153 records in MS Access. when i paste the sql query sql="select * from LeadAssgAmount3" in asp, it is returning 163 instead of 153 records! is there something extra to include in ASP so that queries from MS Access can directly be pasted into asp files and made to work? for e.g., wildcards '*' and '?' dont work in asp, but have to be replaced by '%'.