Hello,
I have a query that I run on a table, "tbl", that has two columns, "col_A" and "col_B". I am running an AND query on the tbl where col_B is "EIS" and col_A has a match for an instr. Here is the query that creates tbl_B24 when the instr function using parameter "B24" returns a match on col_A.
SELECT tbl.[col_A], tbl.col_B INTO tbl_B24
FROM tbl
WHERE (((tbl.col_B)="EIS") And ((InStr(tbl![col_A],"B24"))>"0"));
My question is: Is there a way to run this query n times, where n is the length of list, creating n tables.
For instance:
((InStr(tbl![col_A],"C24"))>"0")) --> create table tbl_C24
((InStr(tbl![col_A],"D24"))>"0")) --> create table tbl_D24
((InStr(tbl![col_A],"E24"))>"0")) --> create table tbl_E24
((InStr(tbl![col_A],"F24"))>"0")) --> create table tbl_F24
Thanks,
radwan
I have a query that I run on a table, "tbl", that has two columns, "col_A" and "col_B". I am running an AND query on the tbl where col_B is "EIS" and col_A has a match for an instr. Here is the query that creates tbl_B24 when the instr function using parameter "B24" returns a match on col_A.
SELECT tbl.[col_A], tbl.col_B INTO tbl_B24
FROM tbl
WHERE (((tbl.col_B)="EIS") And ((InStr(tbl![col_A],"B24"))>"0"));
My question is: Is there a way to run this query n times, where n is the length of list, creating n tables.
For instance:
((InStr(tbl![col_A],"C24"))>"0")) --> create table tbl_C24
((InStr(tbl![col_A],"D24"))>"0")) --> create table tbl_D24
((InStr(tbl![col_A],"E24"))>"0")) --> create table tbl_E24
((InStr(tbl![col_A],"F24"))>"0")) --> create table tbl_F24
Thanks,
radwan