I'm trying to write a query for a query table in Excel, and not having much luck. Help appreciated, and apologies if I've posted this in the wrong forum.
I've got two tables. Item_In records the details (serial, part, date of arrival etc) of items arriving. Item_Action records the details (serial, part, date of processing etc) of what's been done to each item.
What I want is to create a query which will join Item_In and Item_Action, get all instances where the serial field in Item_In is not Null And Item_Action is Null (i.e. where an item has been booked in, but not had anything done to it) and from there use the Item_In date to return an average length of time item have been hanging around awaiting processing.
Is this possible in MS Query, and if so, does anyone know how do do it?