Repost Update Values

[Edgar Thoemmes]

No answer yesterday.....can anyone help?


Sorry SQL should read:

UPDATE Table1 INNER JOIN (tblBookDetails INNER JOIN tblCopies ON
tblBookDetails.BookID = tblCopies.BookID) ON Table1.ISBN =
tblBookDetails.ISBN SET tblCopies.TotalCost = [tblPrices]![UnitPrice];

 

[Michel Walsh]

Hi,


tblPrices is not specified in the FROM clause.


Hoping it may help,
Vanderghast, Access MVP

No answer yesterday.....can anyone help?


Sorry SQL should read:

UPDATE Table1 INNER JOIN (tblBookDetails INNER JOIN tblCopies ON
tblBookDetails.BookID = tblCopies.BookID) ON Table1.ISBN =
tblBookDetails.ISBN SET tblCopies.TotalCost = [tblPrices]![UnitPrice];



--
Many Thanks

Edgar

----------------------------------------------------------------
e dot thoemmes at blueyonder dot co dot uk

I am trying to updates some costs in my database. I have the following
tables:

tblCopies(CopyId, BookID[fk to tblbookdetails], Condition,Price)
tblBookDetail(BoodId, ISBN, Author)
tblBook/AuthortblPrices(ISBN, Quantity, UnitPrice)
tblPrices(ISBN, Quantity, UnitPrice)

I am trying to update the price in tblcopies with the price in tblPrices.
The query must edit the same number of records in tblCopies as is in
the
quantity field in tblPrices. For example I may have 100 copies of BookID 152
but I only want to update 5 of them which is in the Quantity field in
tblprices

My SQL so far:

UPDATE Table1 INNER JOIN (tblBookDetails INNER JOIN tblCopies ON
tblBookDetails.BookID = tblCopies.BookID) ON Table1.ISBN =
tblBookDetails.ISBN SET tblCopies.TotalCost = [Table1]![UnitPrice];