I appreciate it very much..I guess I need it. Thanks!

I wasn't skilled enough to interpret.

This one worked as I had wanted, thanks!

Hi S,

Got an error on this one

Msg 156, Level 15, State 1, Line 44

Incorrect syntax near the keyword 'where'.

select

a.Itemid 'Item',

a.MinInventOnHand 'Min...

I got an error unfortunately. I've marked where the compiler objected.

Msg 8155, Level 16, State 2, Line 43

No column name was specified for column 2 of 'G'.

Msg 207, Level...

I only want a single record, with the new and old code I get every date within that date window.

Thanks for looking, sorry I wasn't clearer.

The InventTrans table contains many dates. I am looking for the most recent date (indicating activity, i.e MAX date) for the itemid within...