Gentlemen | Ladies:

I need sales quantity for 2008 and 2009 for anything with a current on hand quantity.  However, it is not giving me items with a current on hand quantity if there was no sales history at all, ever, regardless of year.  I would think these are null records.  I have “Default Value For Nulls” set and I tried “Left Outer Join” and neither is working.

If I need to do a null formula in Select Expert, could you type that out for me?  I’d greatly appreciate it. I’m new and struggling.  Select Expert currently looks like this:

({IM_ItemWarehouse.QuantityOnHand} <> 0.00) and

{ItemTransactionHistory.TransactionCode} in [“SO”]

(“SO” is my transaction type for sales.  I am grabbing the 2008 and 2009 years outside of Select Expert in a formula field.)

I worked this out last night.  It was via a Mas90 forum, same post.  It had nothing to do with nulls or links.  Check it out.  Good stuff.