the query looks like this:
SELECT calls_listing.dialnumber
FROM calls_listing
WHERE (Len(Trim(calls_listing!dialnumber)) In (10,11)) And ((calls_listing!dialnumber) Like ('072*'));
in Access where i wrote the query it executes fine.
in VB where i have to use it returns no rows !!!!
SELECT calls_listing.dialnumber
FROM calls_listing
WHERE (Len(Trim(calls_listing!dialnumber)) In (10,11)) And ((calls_listing!dialnumber) Like ('072*'));
in Access where i wrote the query it executes fine.
in VB where i have to use it returns no rows !!!!