RE: How to Find the Date of Last Change in Inventory

I don't quite get it. I have some questions:
Are all the items in the same table?
Do you want the highest number of days for all items, or by Style, or by
Style and Color?
How do you come up with 90 days in your second example when the date is
6/15/2005? The differenece between the 5/1/2005 and 6/15/2005 is actually 44
days.
What do you mean by two dates with a change in inventory? I don't see
anything in your example that indicates a "change" in inventory. Are you
saying the date in the record represents an inventory change? That doesn't
seem likely, because many of the records seem to have the same number of
units.
Please post back with some specifics so we can have a crack at it.

"doyle60@xxxxxxx" wrote:

> If I have a table that lists a Style,Color, InventoryUnits, and
> DateOfLastInventory, how can I find the last change in inventory? That
> is, I wish to find Inventory that isn't moving.
>
> For example, let's say I have the following in a table:
>
> Style Color Units Date
> 1912 White 200 01/25/05
> 1912 White 50 02/28/05
> 1912 White 38 03/15/05
> 1912 White 200 05/01/05
> 1912 White 200 06/01/05
> 1912 White 200 06/15/05
>
> I wish to get:
>
> Style Color Units Days
> 1912 White 200 45
>
> Or 45 days between 5/1/ and 6/15 (though it could obviously be more
> days, that is the number I want).
>
> And if I have this:
>
> 2012B Pink 415 01/25/05
> 2012B Pink 248 02/28/05
> 2012B Pink 111 03/15/05
> 2012B Pink 111 05/01/05
> 2012B Pink 111 06/01/05
> 2012B Pink 111 06/15/05
>
> I wish to get:
>
> Style Color Units Days
> 2012B Pink 111 90
>
> And if I have just two dates *with* a change in inventory, or if I have
> only one record for a style/color, it should return 0 days.
>
> Thanks,
>
> Matt
>
>
.

Relevant Pages
Loading