I'm trying to list all "lines" from PO_Detail for a specific PO. Once I find the material class for the specific line I want to look up the customer...

CREATE TABLE [dbo].[SO_Header](

[Sales_Order] [dbo].[Key10] NOT NULL,

[Customer] [dbo].[Key10] NOT NULL,

[Ship_To] [dbo].[KeyNum] NULL,

[Contact] [dbo].[KeyNum] NULL,

[Sales_Rep] [dbo].[Key6] NULL,

[Order_Taken_By] [dbo].[Key6] NULL,

[Ship_Via] [dbo].[T_UCode] NULL,

[Tax_Code] [dbo].[T_UCode] NULL,

[Terms] [dbo].[T_UCode] NULL,

[Sales_Tax_Amt] [money] NOT NULL CONSTRAINT [DF_SO_Header_Sales_Tax_Amt] DEFAULT...

Works perfect. Wasn't sure how the left function would work in my expression as I was already using it. I basically needed it to return only the first...

Magic! Thanks much!

Got it to work! Had an extra , in my code.

I got it to work out. Just had my IIF expression formatted wrong. Thanks again all!

Thanks guys, the MIN function is working great! Now I'm having a little trouble if I only want it to show the MIN date for a specific machine. ...