Search results

Hello, This sql query is very slow in runtime and takes a long time to return the result, because of the in operator inside query(because the second table includes more than 10000 records) i think i have to change it by using Join commands to increase the speed in runtime. but how do i rewrite...

hi guys:) i don't know how should i use substr functions such as substr or instr in a dao sql query!!! for exampe: Select * from Table1 where instr(1,field1,'martin')>0 it doesn't work in vb6 dao(SP6) but it could run in access in one query:confused:.