>Good Morning Cindy...
>Group by works…....thanks....
>The problem was that the part_numbes were not DISTNCT,
>and there were needed values in the same part_number record.
>Example….
>Table1 Value Value
>Part_number 123 25 – (needed value)
>Part_number 123 50 – (needed value)
>
>The problem could be fixed in two ways…
>Way 1….coded extra step and use GROUP BY before running the result query.
>Way 2… in query statement, call a function that gets the DESCRIPTION…example
> SELECT ………….get_desc(arg) AS fld_description…..


Robert - read about LOOKUP() in the Help for getting the description.


>
>Function get_desc
>Parm part_no
>find by part no
>Return fld_description
>
>Thanks all for your help…..