I have a small access 2010 where I keep up with my stock holdings and transactions. I download the stock information in 2 excel spreadsheets (1 from each broker) every day and import them into 2 access tables. I want to bring the current info into a table where I record other specific data but am having trouble. I designed an update query which links the tables by stock symbol. I have the query set to update the "Current Value" field. However when I try to run the query, I get the message "Cannot update the ("expression"). Field not updatable".
If there is a better way, I would certainly appreciate some help!
Thanks, Bill
If there is a better way, I would certainly appreciate some help!
Thanks, Bill