Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update Query

Status
Not open for further replies.

billheath

Technical User
Mar 17, 2000
299
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top