var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Excel crosspost goodness: translating access query to excel
Hiya folks.. I'm trying to figure out an excel only solution to duplicate an access query.
I have a datasource with multiple entries for a given item number. These entries have a date and a quantity attached to them. I want to return the date and quantity for the most recent entry ONLY.
In access I accomplish this like so:
How can I duplicate this behavior in excel and produce a worksheet containing only the records with the most recent "effective date" for a given part?
SELECT SAFETY_STOCK.Item, _STOCK.[Effective Date], SAFETY_STOCK.UOM, SAFETY_STOCK.Quantity
WHERE (((SAFETY_STOCK.[Effective Date])=DMax("[Effective Date]","SAFETY_STOCK","Item = '" & [Item] & "'")))
ORDER BY SAFETY_STOCK.Item;