Search results

Hi members is there any way to list all the tables through sql statement in MS Access.... like in oracle we can use select * from all_tables ?? or select * form cat

in simple my query looks like SELECT Field1, Field2 from table1 where table1.Field2 in (1,2,3) and now i need to parameterize this query.... I tried with SELECT Field1, Field2 from table1 where table1.Field2 in ([Parameter]) Now the problem is... it is working fine with only one value For...