I'm also attaching a jpg that shows the relationships.
UPDATE tblPositionSymbol INNER JOIN (tblShrtName INNER JOIN (Newposition INNER JOIN tblPosition ON Newposition.ID = tblPosition.PositionID) ON tblShrtName.ID = tblPosition.tblShrtName_ID) ON tblPositionSymbol.ID = tblPosition.tblPositionSymbol_ID SET tblPosition.quantity = [newposition].[quantity], tblPosition.cost = [newposition].[cost], tblPosition.[$gain/loss] = [newposition].[$gain/loss], tblPosition.[mkt value] = [newposition].[mkt value], tblPositionSymbol.[as of date] = [newposition].[as of date];
|Syntax error [Missing Operator] in query expression||7||26|
|Field Size - Double? Want to display 0||5||30|
|MS Access 2010 : hyperlink to picture in report doesn't show picture||2||13|
|How do I refer to a session variable in a query?||4||20|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!