Hi all,
I'm a newbie to Access programming and am having a hard time
performing what may seem like a simple task to you all. Here's what
i'm dealing with:
I have 10 tables which are formatted in the same manner - each table
represents a stock with historical prices at different dates. There
will be more tables added as we add more stocks to the mix; however,
please note that all the tables are identical in field structure. Now,
here's what I am trying to accomplish - I am creating a form which
would list out all the stocks in the database. I need to allow the
user to pick any of the stocks he wants in his portfolio, press a
button, and then an output would be generated which combines the
tables of the stocks into one big table, which would essentially be
the output. How do I do this - can someone please help?
I appreciate any or all help - thank you in advance!
I'm a newbie to Access programming and am having a hard time
performing what may seem like a simple task to you all. Here's what
i'm dealing with:
I have 10 tables which are formatted in the same manner - each table
represents a stock with historical prices at different dates. There
will be more tables added as we add more stocks to the mix; however,
please note that all the tables are identical in field structure. Now,
here's what I am trying to accomplish - I am creating a form which
would list out all the stocks in the database. I need to allow the
user to pick any of the stocks he wants in his portfolio, press a
button, and then an output would be generated which combines the
tables of the stocks into one big table, which would essentially be
the output. How do I do this - can someone please help?
I appreciate any or all help - thank you in advance!