Basically the table has every purchase order placed in the last year along with the part number, description, accountnum, orderdate, and recieve date.
Now, We are trying to figure out a way to calculate our average lead time on these orders for one year, 6months, and 3months. The lead time would be our orderdate - recievedate. My problem is calculating the average lead times.
Here is what I have so far.
SELECT partNum, description, accountNo, DateDiff("d",poDate,dateRecvd) AS leadTime FROM Leadtime;
Anyone have any ideas how to calculate the average leadTime and only show one record of each part?