Okay, I have the MS SQL query how do I convert this to access?

UPDATE OrderDetails

SET ShipID = LatestShipping

from OrderDetails

...

How to I fix this error:

Column 'Shipping.EEID' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

UPDATE ...

I think that is where my problem lies. See in order to update the orderdetails.shipid to what is in the shipping.shipid, I have to somehow join the orders table in...