T
toby
i 've 3 data base source in excel files (file A1, B1 & C1) which would be
updated periodically.
i've made an union query to generate the file list following my criteria
input already and it works.
the data base format of the 3 files is as follows:
column
A B C D E
012 .. .. .... ...
013 .. .. ....... .....
016 .. .. ....... .....
016 .. .. ....... .....
012 .. .. ....... .....
019 .. .. ....... .....
so can i make a query table with coresponding box of "012, "016, "019
&........; so that i can click these box to choose the criteria i want for
the required list?? let's say if i click the box 012, 016, 019, then the
rows of data with 012, 016, 019 in column A will be selected out together
from the 3 files source .
how to do this.?
thanks in advance
updated periodically.
i've made an union query to generate the file list following my criteria
input already and it works.
the data base format of the 3 files is as follows:
column
A B C D E
012 .. .. .... ...
013 .. .. ....... .....
016 .. .. ....... .....
016 .. .. ....... .....
012 .. .. ....... .....
019 .. .. ....... .....
so can i make a query table with coresponding box of "012, "016, "019
&........; so that i can click these box to choose the criteria i want for
the required list?? let's say if i click the box 012, 016, 019, then the
rows of data with 012, 016, 019 in column A will be selected out together
from the 3 files source .
how to do this.?
thanks in advance