Hello all,
I know this is probably a very easy question, but somehow I am just confused...
I have a table, say for example, srcTab that has a couple of columns (say "age", "sex", ...) that I need to select into a new table that I would like to make (call it tarTable) and on top of that, I have a couple sets of computed numbers corresponding to each record in the srcTab that I would like to add into the new table, and those numbers were computed in the VBA code (say age_loop, where you loop through each age from the current age to 18), and make each record a unique row. So that essentially, I will have my tarTable with
number of records in the srcTab * number of ages b/t current age and 18
records,
with each record containing
"age", "sex" and "age_loop" columns
How can I get that done? Please enlighten me.
Thanks!
I know this is probably a very easy question, but somehow I am just confused...
I have a table, say for example, srcTab that has a couple of columns (say "age", "sex", ...) that I need to select into a new table that I would like to make (call it tarTable) and on top of that, I have a couple sets of computed numbers corresponding to each record in the srcTab that I would like to add into the new table, and those numbers were computed in the VBA code (say age_loop, where you loop through each age from the current age to 18), and make each record a unique row. So that essentially, I will have my tarTable with
number of records in the srcTab * number of ages b/t current age and 18
records,
with each record containing
"age", "sex" and "age_loop" columns
How can I get that done? Please enlighten me.
Thanks!
