Skip to Content
0
Former Member
Sep 07, 2010 at 02:27 PM

Formula to select first record on the column

12 Views

Hi All

I need a formula to select a first record on the column, here is my query

SELECT DISTINCT 
                      dbo.OWOR.DocNum, dbo.OWOR.ItemCode, dbo.OWOR.Status, dbo.OWOR.PlannedQty, dbo.ITM1.Price, dbo.OWOR.Warehouse, 
                      dbo.OWOR.PlannedQty * dbo.ITM1.Price AS Total
FROM         dbo.OWOR INNER JOIN
                      dbo.ITM1 ON dbo.OWOR.ItemCode = dbo.ITM1.ItemCode
WHERE     (dbo.OWOR.Status = 'P') OR
                      (dbo.OWOR.Status = 'R') AND dbo.ITM1.Price

I need to select the first price on the price list for (dbo.ITM1.Price).

Regards

Bongani