very new (basic question) & bloomberg Options

[jason]

hello,
please humor my lack of knowledge as I am very new to access.
basically: i want to build a database that appends data to the end of
certain fields of a table.

as in database values: stock price volume (@ time=yesterday)
today: stock price volume (@time = end of today)
i want to automatically add today's data to the end of my table's
data
automatically.

also, i am trying to do this using bloomberg api.

if anyone has any specialty w interfacing access & bloomberg it would
be an additionally large help.
thanks

 

[John W. Vinson]

hello,
please humor my lack of knowledge as I am very new to access.
basically: i want to build a database that appends data to the end of
certain fields of a table.

as in database values: stock price volume (@ time=yesterday)
today: stock price volume (@time = end of today)
i want to automatically add today's data to the end of my table's
data
automatically.

No. You don't.

You want to *add a new record* to the table. You do not want to have a single
record in the table that keeps getting bigger and bigger every day. That's
simply not how relational databases work!

also, i am trying to do this using bloomberg api.

You'll have to get in touch with Bloomberg for that, I suspect.