Update Field list in Table with Query

[Scorpio11]

Is it possible to update the field listing of a table based on the data stored in another table.



I am building something that involves shares and stocks. When i purchase another stock - I would record the details of the stock in Table 1 then I would like it to be able to add a new field in Table 2 where i can record the daily closing price.

The closest i can find is an update query, but that only updates values in a table, not the actual table itself.....

Any help would be appreciated.

[TheShabz]

What I would do is create the table with stock info like you have. I would create a second table with fields

StockTrackID (autonumber PK)
StockID (FK)
OpenPrice
ClosePrice
Date

You create a 1-M relationship between the tables. You run an INSERT INTO query (most likely off of a form) to add fields to the second table. I hope I'm getting the gist of what youre trying to accomplish.

[Scorpio11]

I follow what you are suggesting and in theory does sound like it could work - my only issue is the INSERT INTO query - i don't know how to do that - i don't see that option as a query type. An i don't know how to build a query..? any suggestions?

[TheShabz]

you would have to do it in VBA. i really cant write it out for you without seeing the db. look up...
http://www.blueclaw-db.com/accessque...nsert_into.htm
for the insert into. also look up how to put variables into a string. get started on that, get a rough sql string made up and i can fine-tune it for ya.