Hit the Reply button to see how to format your code and maintain spacing.

The following worked on your data. I did change the field names to avoid reserved words:

select nrow, min(ncolumn) cLow, max(ncolumn) cHigh, min(cLevel) lLow, max(cLevel) lHigh from test group by nrow

>I have a table based on a warehouse inventory. Each record represents an item in the inventory and contains an Item #, ROW, COLUMN AND LEVEL. What I need to do is return a value for each unique row with the high and low values for column and level. See sample data below: (sorry about the lack of spacing. I don't know how to stop UT from removing spaces)

>
>
>Item        Row         Column        Level
>
>123         1            02           A
>234         2            05           D
>345         3            01           A
>456         1            01           F
>567         2            03           A
>678         3            07           H
>789         1            04           C
>890         2            01           L
>901         3            09           F
>
>
>This should return
>
>row        clow       chigh      llow       lhigh
>1          01          04         A          F
>2          01          05         A          L
>3          01          09         A          H

>Thanks for any help